NTSB investigations, 1990, NH
180,604 investigations by the National Transportation Safety Board since 1962: 174,583 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\") = 1990
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") = 1990 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 NYC91LA052Accident · No injuriesLimited investigationFinal reportBeech 35-C33 · Concord, NHThe improper starting procedure used by the pilot.NTSB NYC91LA029Accident · 1 fatalLimited investigationFinal reportPiper PA-32-301R · Alton, NHThe total loss of engine power for undetermined reasons. Contributing to the severity of the accident was the unsuitable terrain in which the forced landing was made.NTSB NYC91DNC02Accident · Serious injuriesFinal reportMarier Early Bird Jenny · Concord, NHThe failure of the pilot to maintain adequate airspeed, which resulted in an inadvertent stall spin. A factor related to the accident was: the pilot's lack of experience in the make and model of aircraft.NTSB NYC91FA001Accident · 3 fatalField investigationFinal reportCessna 172P · Gorham, NHImproper planning/decision by the pilot, and his failure to maintain proper altitude while flying over mountainous terrain. Factors related to the accident were: darkness, mountainous terrain, and pilot fatigue.NTSB NYC90DNC01Accident · Serious injuriesFinal reportCessna 180E · Kingston, NHAn inflight collision with water while maneuvering for a forced landing. A factor to the accident was a power loss due to the pilot's improper use of the mixture control.NTSB NYC90LA228Accident · Minor injuriesLimited investigationFinal reportPiper PA-12 · Franconia, NHThe landing of the airplane in unsuitable terrain, due to the mechanical failure of the engine center muffler baffle, which blocked the exhaust flow, resulting in a loss of power.NTSB NYC90LA202Accident · No injuriesLimited investigationFinal reportWaco DSO · Keene, NHAborted takeoff with insufficient room available to stop. The pilot's delayed decision to abort the takeoff was a factor.NTSB NYC90LA188Accident · No injuriesLimited investigationFinal reportCessna 150M · Rochester, NHUndetermined.NTSB NYC90LA069Accident · No injuriesLimited investigationFinal reportCessna 172P · Sunapee Lake, NHFailure of the pilot to maintain adequate altitude above the lake, which resulted in unplanned contact with its frozen surface.