Fatal NTSB investigations, 1985, NH
180,658 investigations by the National Transportation Safety Board since 1962: 174,636 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 | 2 |
|---|---|
| 1966 | 3 |
| 1967 | 5 |
| 1968 | 5 |
| 1969 | 2 |
| 1970 | 1 |
| 1971 | 6 |
| 1972 | 4 |
| 1973 | 5 |
| 1974 | 3 |
| 1975 | 2 |
| 1977 | 3 |
| 1978 | 3 |
| 1979 | 4 |
| 1980 | 1 |
| 1981 | 2 |
| 1982 | 5 |
| 1983 | 4 |
| 1984 | 4 |
| 1985 | 4 |
| 1986 | 3 |
| 1987 | 4 |
| 1989 | 1 |
| 1990 | 2 |
| 1991 | 3 |
| 1992 | 2 |
| 1993 | 5 |
| 1996 | 3 |
| 1997 | 2 |
| 1998 | 2 |
| 1999 | 2 |
| 2000 | 2 |
| 2001 | 2 |
| 2002 | 2 |
| 2004 | 1 |
| 2005 | 3 |
| 2009 | 1 |
| 2012 | 2 |
| 2014 | 1 |
| 2015 | 1 |
| 2017 | 1 |
| 2021 | 3 |
| 2022 | 1 |
| 2023 | 2 |
Where
Latest 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\") = 1985
AND c.\"eventStateOrRegion\" = 'NH' AND c.\"eventCountry\" = 'USA'
AND c.\"highestInjuryLevel\" = 'Fatal'
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") = 1985 AND c."eventStateOrRegion" = 'NH' AND c."eventCountry" = 'USA' AND c."highestInjuryLevel" = 'Fatal' 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 NYC86FA023Accident · 2 fatalField investigationFinal reportCessna 172N · Rochester, NHDuring landing approach to runway 32, the aircraft started to porpoise over the runway. The aircraft continued in this manner until it neared the end of the runway. The aircraft then started a slow climbing right turn just clearing nearby trees. The…NTSB NYC86FA017Accident · 1 fatalField investigationFinal reportSchweizer SGS-1-35C · North Conway, NHDuring an off airport landing attempt in a cleared corn field, the glider was approaching a treeline at an altitude of 10 to 20 ft AGL. Witnesses observed the glider pull up and bank to the left before falling nose first into the ground. The pilot's log book…NTSB NYC85FA109Accident · 2 fatalField investigationFinal reportPiper PA-28-140 · No. Hampton, NHOn April 20, 1985, a Piper PA-28-140, flown by a student plt, crashed during an attempted go-around at north Hampton, NH, while on a pleasure flt. The wx was clear, winds were light and variable with unlimited visibility. The tough rwy is 2050 ft long and 300…NTSB NYC85FA060Accident · 4 fatalField investigationFinal reportPiper PA-31-350 · Whitefield, NHThe acft crashed after executing a missed approach at Whitefield during IMC wx. The acft was seen at 300-400 ft AGL during some part of the maneuvering near the arpt. The acft seemed to be heading for the arpt when last seen by ground observers. The only…