NTSB investigations, 1993, NH
180,610 investigations by the National Transportation Safety Board since 1962: 174,589 accidents, the rest incidents and other occurrences. Each has NTSB’s narrative and, once the investigation is done, its probable cause; since 2008, its findings and sequence of events.
Cases per year
| 1964 | 14 |
|---|---|
| 1965 | 20 |
| 1966 | 18 |
| 1967 | 26 |
| 1968 | 21 |
| 1969 | 18 |
| 1970 | 7 |
| 1971 | 18 |
| 1972 | 27 |
| 1973 | 27 |
| 1974 | 17 |
| 1975 | 18 |
| 1976 | 9 |
| 1977 | 21 |
| 1978 | 20 |
| 1979 | 14 |
| 1980 | 20 |
| 1981 | 5 |
| 1982 | 18 |
| 1983 | 19 |
| 1984 | 16 |
| 1985 | 12 |
| 1986 | 18 |
| 1987 | 18 |
| 1988 | 16 |
| 1989 | 6 |
| 1990 | 9 |
| 1991 | 15 |
| 1992 | 9 |
| 1993 | 13 |
| 1994 | 13 |
| 1995 | 6 |
| 1996 | 11 |
| 1997 | 9 |
| 1998 | 7 |
| 1999 | 6 |
| 2000 | 11 |
| 2001 | 11 |
| 2002 | 3 |
| 2003 | 4 |
| 2004 | 8 |
| 2005 | 12 |
| 2006 | 5 |
| 2007 | 9 |
| 2008 | 6 |
| 2009 | 4 |
| 2010 | 4 |
| 2011 | 5 |
| 2012 | 4 |
| 2013 | 6 |
| 2014 | 6 |
| 2015 | 6 |
| 2016 | 13 |
| 2017 | 5 |
| 2018 | 4 |
| 2019 | 4 |
| 2020 | 6 |
| 2021 | 5 |
| 2022 | 5 |
| 2023 | 6 |
| 2024 | 7 |
| 2025 | 7 |
| 2026 | 6 |
Where
Open the mapLatest cases
Query with SQL
duckdb -csv -c "SELECT c.\"ntsbNumber\", c.\"eventDate\", c.\"eventType\", c.\"eventCity\", c.\"eventStateOrRegion\", a.n_number, a.\"aircraftMake\", a.\"aircraftModel\", c.\"highestInjuryLevel\", c.\"totalFatal\", c.\"completionStatus\", c.report_url
FROM 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = c.\"mKey\" AND a.position = 1
WHERE year(c.\"eventDate\") = 1993
AND c.\"eventStateOrRegion\" = 'NH' AND c.\"eventCountry\" = 'USA'
ORDER BY c.\"eventDate\" DESC, c.\"ntsbNumber\" DESC"Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.
SELECT c."ntsbNumber", c."eventDate", c."eventType", c."eventCity", c."eventStateOrRegion", a.n_number, a."aircraftMake", a."aircraftModel", c."highestInjuryLevel", c."totalFatal", c."completionStatus", c.report_url FROM 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = c."mKey" AND a.position = 1 WHERE year(c."eventDate") = 1993 AND c."eventStateOrRegion" = 'NH' AND c."eventCountry" = 'USA' ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
NTSB NYC94LA043Accident · No injuriesLimited investigationFinal reportBeech A-36-TC · Hillsboro, NHLoss of engine power for undetermined reasons.NTSB NYC94FA029Accident · 2 fatalField investigationFinal reportAerospatiale TB-21 · Lebanon, NHThe pilot's failure to maintain adequate terrain clearance which resulted in an inflight collision with the terrain. A factor was a dark night condition.NTSB NYC94LA024Accident · No injuriesLimited investigationFinal reportPiper J3 · Greenland, NHThe pilot's improper landing flare which resulted in a hard landing.NTSB NYC93LA181Accident · No injuriesLimited investigationFinal reportBeech 19 · Wolfboro, NHThe pilot's failure to abort the takeoff which resulted in an overrun of the runway. Factors were a dirt bank, and the pilot's premature lift off, his failure to attain adequate airspeed, and his lack of recency of experience.NTSB NYC93LA172Accident · 1 fatalLimited investigationFinal reportBellanca 7ECA · Ashland, NHThe pilot's improper decision to leave the airplane unattended with the engine operating.NTSB NYC93LA143Accident · Serious injuriesLimited investigationFinal reportBalloon Works Fire FLY 7-15 · Milford, NHUnfavorable winds during landing which resulted in a hard landing and one passenger sustaining a broken angle.NTSB BFO93LA139Accident · Serious injuriesLimited investigationFinal reportTaylorcraft BF12-65 · Sunappee, NHThe passenger's failure to follow proper procedures and inadequate supervision by the pilot.NTSB BFO93FA135Accident · 2 fatalField investigationFinal reportKrowell Christen Eagle II · Lebanon, NHInadequate crew/group coordination.NTSB BFO93FA103Accident · 2 fatalField investigationFinal reportCessna 180K · Webster, NHThe pilot's inadequate preflight planning/preparation, his failure to assure proper weight and balance of the aircraft for takeoff, and his failure to obtain and/or maintain adequate airspeed, which resulted in a stall. A possible factor related to the…NTSB NYC93FA127Accident · 2 fatalField investigationFinal reportBoeing Stearman PT-17 · Concord, NHLoss of airplane control as the result of incapacitation.NTSB BFO93LA099Accident · No injuriesLimited investigationFinal reportCessna 177 · Newport, NHThe pilot's failure to properly recover from a bounced landing, and his failure to maintain directional control during the aborted landing.NTSB NYC93LA078Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Durham, NHImproper planning/decision by the pilot, which resulted in fuel exhaustion and loss of engine power. Factors related to the accident were flight into adverse weather conditions, failure to obtain inflight weather information, and pilot fatigue.NTSB BFO93LA020Accident · No injuriesLimited investigationFinal reportDornier DO-228-202 · Manchester, NHIncorrect installation of the seals in the nose gear assembly, which prevented the nose gear from locking in the down position.