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

19642026
NTSB investigations, 2004, 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\") = 2004
    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 IAD05LA010Accident · No injuriesLimited investigationFinal reportCessna 172 · Wolfeboro, NHA jammed control wheel during landing. A contributing factor to the accident was the inadequate maintenance inspection of the airplane's flight control system.Nov 4, 2004 · N8803B · Substantial damageNTSB NYC05CA004Accident · Minor injuriesData collectionFinal reportBoeing Stearman B75-N1 · Jaffery, NHThe pilots inadvertent encounter with a downdraft wind condition and the airplane's inability to climb, which resulted in a forced landing. A factor related to the accident was the downdraft wind conditions.Oct 9, 2004 · N49738 · Substantial damageNTSB NYC04LA212Accident · No injuriesLimited investigationFinal reportCessna 182H · Nashua, NHAn in flight collision with birds while landing. A factor was the night conditions.Sep 9, 2004 · N8463S · Substantial damageNTSB NYC04LA193Accident · Minor injuriesLimited investigationFinal reportGlobe Swift GC-1B · Wolfeboro, NHThe pilot's inadequate compensation for wind condition. The windshear was a contributing factor.Aug 14, 2004 · N78176 · Substantial damageNTSB NYC04LA160Accident · Serious injuriesLimited investigationFinal reportPiper PA-12 · Jaffrey, NHThe loss of engine power for undetermined reasons.Jul 7, 2004 · N2489M · Substantial damageNTSB NYC04FA157Accident · 1 fatalField investigationFinal reportLake LA-4-200 · Wilmot, NHThe pilot's continued VFR flight into IMC conditions, and his failure to maintain terrain clearance, which resulted in a controlled flight into terrain. Factors in the accident were the low cloud ceiling and the pilot's lack of recent instrument time.Jul 5, 2004 · N6248V · Substantial damageNTSB NYC04IA152Incident · No injuriesIncident investigationFinal reportAirbus Industrie A319-114 · Manchester, NHThe Airbus captain's misjudged clearance, which resulted the left wing of the Airbus contacting the rudder of the stationary Canadair.Jun 30, 2004 · N348NB · 2 aircraft · Minor damageNTSB IAD04CA010Accident · No injuriesData collectionFinal reportPiper PA-20 · West Ossipee, NHThe pilot's inability to maintain runway alignment during the landing rollout. Factors included the night lighting conditions and the snow banks that prevented visual reference to the runway lights.Feb 11, 2004 · N2634A · Substantial damage