NTSB investigations, 2015, 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, 2015, 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\") = 2015
    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 GAA16CA016Accident · No injuriesData collectionFinal reportCentral Missouri State Univ HP 14 · Jackson, NHThe glider pilot's decision to descend into a broken to overcast cloud layer, which resulted in encountering instrument meteorological conditions and the pilot parachuting from the glider. Contributing to the accident was the pilot's lack of planning for an…Oct 14, 2015 · N102MW · Substantial damageNTSB ERA15LA339Accident · 1 fatalLimited investigationFinal reportEvolution Revo · Laconia, NHThe sport pilot’s improper decision to operate the weight-shift-control aircraft at low altitude and his subsequent failure to maintain control of the aircraft, which resulted in a subsequent collision with terrain.Sep 5, 2015 · N2264X · Substantial damageNTSB GAA15CA127Accident · No injuriesData collectionFinal reportPaquin Michael A A · Concord, NHThe pilot's inability to maintain directional control during takeoff, which resulted in a roll over. Contributing to the loss of control was the pilot's failure to disengage the main rotor brake prior to takeoff.Jun 20, 2015 · N485MP · Substantial damageNTSB ERA15FA241Accident · Serious injuriesField investigationFinal reportPiper PA-22 · Laconia, NHA total loss of engine power for reasons that could not be determined because of insufficient evidence found during postaccident examination of the airframe and engine.Jun 18, 2015 · N2569P · Substantial damageNTSB ERA15LA237Accident · Serious injuriesLimited investigationFinal reportPiper PA28 · Hampton, NHThe pilot’s failure to properly set the stabilator trim prior to takeoff, which resulted in an exceedance of the airplane’s critical angle of attack and an aerodynamic stall during takeoff.Jun 14, 2015 · N43078 · Substantial damageNTSB ERA15CA113Accident · No injuriesData collectionFinal reportCessna 172I · Nashua, NHThe student pilot's lack of vigilance during taxi, which resulted in a collision with a parked truck. A factor in the accident was the truck operator's decision to park on the edge of an active taxiway.Jan 23, 2015 · N35560 · Substantial damage