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

19642026
Fatal NTSB investigations, 1985, NH per year, 1964–2026: 119 cases
19642
19663
19675
19685
19692
19701
19716
19724
19735
19743
19752
19773
19783
19794
19801
19812
19825
19834
19844
19854
19863
19874
19891
19902
19913
19922
19935
19963
19972
19982
19992
20002
20012
20022
20041
20053
20091
20122
20141
20151
20171
20213
20221
20232

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.

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…Oct 27, 1985 · N734PX · DestroyedNTSB 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…Oct 25, 1985 · N2565H · DestroyedNTSB 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…Apr 20, 1985 · N95043 · DestroyedNTSB 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…Feb 2, 1985 · N27522 · Destroyed