NTSB investigations, 2014, IN

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

19632026
NTSB investigations, 2014, IN per year, 1963–2026: 2,978 cases
19631
1964107
1965116
1966119
1967132
1968106
196988
197083
197181
197288
197377
197466
197586
197678
197790
197895
197970
198076
198152
198255
198354
198455
198554
198658
198753
198866
198945
199042
199133
199229
199335
199438
199533
199631
199736
199835
199922
200034
200129
200225
200320
200426
200520
200628
200723
200822
200930
201027
201126
201226
201322
201416
201519
201623
201722
201819
201922
202017
202121
202221
202316
202417
202513
20269

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\") = 2014
    AND c.\"eventStateOrRegion\" = 'IN' 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 CEN15LA026Accident · 1 fatalLimited investigationFinal reportStephenson Stol CH 701 · Mount Vernon, INThe pilot’s impairment due to the ingestion of alcohol and sedating medications, which led to her improper decision to conduct low-level flight, affected her ability to safety operate the airplane, and resulted in her failure to maintain clearance from power…Oct 24, 2014 · N34WS · Substantial damageNTSB CEN14LA519Accident · No injuriesLimited investigationFinal reportPiper PA 36-285 · Woodburn, INA loss of engine power during takeoff for reasons that could not be determined based on the available information.Sep 19, 2014 · N9913P · Substantial damageNTSB CEN14LA504Accident · 2 fatalLimited investigationFinal reportSaccio Thomas A Seawind 3000 · Bloomington, INAn in-flight fire for reasons that could not be determined because the examination of the airplane did not reveal the source of the fire.Sep 18, 2014 · N516SW · DestroyedNTSB CEN14CA481Accident · Minor injuriesData collectionFinal reportPiper PA 28-140 · Plymouth, INThe sun glare and the pilot's subsequent loss of airplane control.Sep 1, 2014 · N8307R · Substantial damageNTSB CEN14CA422Accident · No injuriesData collectionFinal reportPiper PA 32-300 · Warsaw, INThe pilot failed to maintain directional control during landing.Jul 31, 2014 · N8160A · Substantial damageNTSB CEN14CA381Accident · No injuriesData collectionFinal reportCessna 150D · Greenfield, INThe student pilot failed to maintain directional control while landing with a crosswind.Jul 21, 2014 · N4545U · Substantial damageNTSB CEN14LA374Accident · No injuriesLimited investigationFinal reportCessna 172N · Rockville, INA partial loss of engine power due to a failure of the dual magneto system. Contributing to the accident was the improper maintenance of the duel magneto system.Jul 16, 2014 · N13SK · Substantial damageNTSB CEN14FA356Accident · 1 fatalField investigationFinal reportMooney M20M · Greenwood, INA partial loss of engine power for reasons that could not be determined because postaccident examination of the airframe and engine did not reveal any anomalies that would have precluded normal operation. Also causal to the accident was the pilots' decision…Jul 11, 2014 · N72FG · Substantial damageNTSB CEN14LA327Accident · Minor injuriesLimited investigationFinal reportCessna T207 · Indianapolis, INA loss of engine power due to fuel starvation, which resulted from the pilot's failure to monitor the fuel level and switch tanks in a timely fashion.Jun 27, 2014 · N207AB · Substantial damageNTSB CEN14CA322Accident · No injuriesData collectionFinal reportCessna 172S · Knox, INThe student pilot's use of excessive back pressure on the flight controls during an attempted go around that induced a stall and loss of control.Jun 25, 2014 · N1307C · Substantial damageNTSB CEN14LA307Accident · No injuriesLimited investigationFinal reportRotorway Exec 162F · Mt. Comfort, INThe pilot’s installation of an unauthorized main rotor belt and his subsequent failure to properly inspect the belt, which resulted in inadequate belt tension, the belt’s failure, and the subsequent loss of engine power.Jun 21, 2014 · N6828D · Substantial damageNTSB CEN14LA243Accident · 1 fatalLimited investigationFinal reportHoffius Stowe Challenger II · Attica, INThe pilot’s failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle-of-attack while maneuvering at low altitude, which led to an aerodynamic stall and loss of control. Contributing to the accident was the installation of an…May 10, 2014 · N824SH · Substantial damageNTSB CEN14CA231Accident · Minor injuriesData collectionFinal reportPiper J3C 65 · Connersville, INThe pilot's inability to control the airplane while taxiing due to a strong crosswind condition.May 3, 2014 · N6245H · Substantial damageNTSB CEN14CA207Accident · No injuriesData collectionFinal reportFlight Design Ctsw · Bloomington, INThe pilot did not maintain control of the airplane while landing.Apr 19, 2014 · N298AB · Substantial damageNTSB CEN14LA161Accident · Serious injuriesLimited investigationFinal reportCessna 150M · Greenwood, INThe flight instructor's failure to ensure that carburetor heat was used while performing maneuvers at reduced power settings in conditions conducive to the formation of carburetor ice, which resulted in a partial loss of engine power due to carburetor ice.…Mar 18, 2014 · N9432U · Substantial damageNTSB CEN14CA155Accident · No injuriesData collectionFinal reportCessna 172M · South Bend, INThe pilot involved and the phase of flight when the damage was incurred were not determined.Feb 26, 2014 · N9801V · Substantial damage