NTSB investigations, 1992, 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

19642026
NTSB investigations, 1992, NH per year, 1964–2026: 713 cases
196414
196520
196618
196726
196821
196918
19707
197118
197227
197327
197417
197518
19769
197721
197820
197914
198020
19815
198218
198319
198416
198512
198618
198718
198816
19896
19909
199115
19929
199313
199413
19956
199611
19979
19987
19996
200011
200111
20023
20034
20048
200512
20065
20079
20086
20094
20104
20115
20124
20136
20146
20156
201613
20175
20184
20194
20206
20215
20225
20236
20247
20257
20266

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\") = 1992
    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.

NTSB NYC93LA041Accident · Minor injuriesLimited investigationFinal reportCessna T210 · Londonderry, NHThe pilot's inadequate inflight decision which resulted in fuel exhaustion and the loss of engine power. Contributing was the pilot's inadequate preflight planning and preparation.Dec 13, 1992 · N210PQ · Substantial damageNTSB NYC93LA036Accident · Minor injuriesLimited investigationFinal reportPiper PA-32RT-301T · Jaffrey, NHAn improper weld by other maintenance personnel which resulted in the nose gear collapsing, and a loss of directional control on takeoff.Dec 6, 1992 · N3017P · Substantial damageNTSB NYC93LA008Accident · No injuriesLimited investigationFinal reportCessna 152 II · Milford, NHThe instructor pilots improper in-flight planning, and his failure to maintain a proper glide path to the forced landing area. A factor in this accident was the instructor's decision to shut down the engine during a 'simulated' engine failure .Oct 5, 1992 · N301DW · Substantial damageNTSB NYC93LA004Accident · 1 fatalLimited investigationFinal reportLake LA-250 · Franklin, NHThe pilot's misjudged touchdown on the water which resulted in a porpoised landing. Also causal to the accident was his improper recovery from the porpoise, resulting in a loss of airplane control and collision with the water. Factors related to the accident…Oct 3, 1992 · N8549Z · Substantial damageNTSB NYC92LA154Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Keene, NHAn inadvertent stall during flap retraction, following an aborted landing.Aug 10, 1992 · N738FW · Substantial damageNTSB BFO92LA110Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Belmont, NHInadequate in-flight planning/decision by the pilot.Jul 22, 1992 · N93361 · Substantial damageNTSB BFO92LA099Accident · Serious injuriesLimited investigationFinal reportPiper PA28-161 · Brentwood, NHA delay by the pilot in aborting the landing which resulted in failure to clear the obstacles.Jul 12, 1992 · N31683 · DestroyedNTSB BFO92FA094Accident · 2 fatalField investigationFinal reportMitsubishi MU-2B-40 · Concord, NHLoss of control during flight for undetermined reason(s).Jul 9, 1992 · N220MA · DestroyedNTSB NYC92LA121Accident · Serious injuriesLimited investigationFinal reportBellanca 7GCBC · Bedford, NHPhysical impairment of the pilot as the result of alcohol consumption, resulting in his failure or inability to maintain control of the airplane. Factors which contributed to the accident were: the pilot's poor judgement in buzzing residences and his failure…Jun 19, 1992 · N8736V · Substantial damage