Final NTSB investigations, IN
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, newest first
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 c.\"eventStateOrRegion\" = 'IN' AND c.\"eventCountry\" = 'USA'
AND c.\"completionStatus\" = 'Completed'
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.
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 c."eventStateOrRegion" = 'IN' AND c."eventCountry" = 'USA' AND c."completionStatus" = 'Completed' ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
NTSB CEN20FA098Accident · 1 fatalClass 3 · FieldFinal reportInnovator Mosquitto · North Manchester, INThe pilot’s loss of control for reasons that could not be determined based on the available information.NTSB CEN20FA038Accident · 1 fatalClass 3 · FieldFinal reportPiper PA28 · Evansville, INThe pilot’s failure to maintain control of the airplane.NTSB GAA20CA063Accident · Minor injuriesData collectionFinal reportSikorsky S 58JT · Lebanon, INThe pilot's failure to maintain proper clearance from a tractor trailer during landing.NTSB CEN20FA002Accident · 1 fatalClass 3 · FieldFinal reportPiper Aerostar 602P · Kokomo, INThe pilot's exceedance of the airplane’s critical angle of attack following a dual engine power loss caused by the line service technician fueling the airplane with the wrong fuel, which resulted in an aerodynamic stall and subsequent loss of control.…NTSB GAA19CA571Accident · No injuriesData collectionFinal reportCessna 152 · Lafayette, INThe student pilot's improper landing flare, which resulted in a bounced landing and subsequent nose landing gear collapse.NTSB GAA19CA569Accident · No injuriesData collectionFinal reportDiamond DA20 · Fort Wayne, INThe pilot's improper preflight fuel planning, which resulted in fuel exhaustion, a total loss of engine power, and impact with a tree during an off-airport landing.NTSB CEN19LA320Accident · Minor injuriesClass 2 · LimitedFinal reportCirrus SR22 · Hoagland, INA catastrophic engine failure and forced landing due to the separation of the No. 1 connecting rod as a result of migration of the connecting rod piston pin bushing. Contributing to the accident was the mechanic’s failure to follow manufacturer guidance…NTSB CEN19LA309Accident · No injuriesClass 3 · LimitedFinal reportBell 206 · Walkerton, INThe partial loss of engine power due to fuel contamination.NTSB CEN19TA293Accident · No injuriesClass 3Final reportPiper J3C · Russiaville, INThe pilot's failure to reinstall the oil cap after adding oil, which resulted to oil starvation and a precaautionary landing.NTSB CEN19LA225Accident · Serious injuriesClass 3 · LimitedFinal reportCessna T188 · Knox, INThe pilot's exceedance of the airplane's critical angle of attack, which resulted in an aerodynamic stall and loss of airplane control.NTSB CEN19LA223Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 177 · Elkhart, INAn inadvertent engine start of the airplane and subsequent takeoff without the pilot on-board for reasons that could not be determined based on available evidence.NTSB GAA19CA392Accident · No injuriesData collectionFinal reportNorth Wing Uum Scout · Westfield, INThe student pilot's improper landing flare, which resulted in a bounced landing and wing strike.NTSB CEN19FA195Accident · 1 fatalClass 2 · FieldFinal reportRans S12 · Orleans, INThe pilot's exceedance of the airplane's critical angle of attack while maneuvering toward the runway, which resulted in an aerodynamic stall and a loss of control.NTSB CEN19LA163Accident · Serious injuriesClass 3 · LimitedFinal reportGriff Challenger · Switz City, INA total loss of engine power due to failure of a connecting rod bearing. Contributing to the engine failure was the lack of an engine overhaul within the prescribed interval.NTSB GAA19CA330Accident · No injuriesData collectionFinal reportDiamond DA20 · Terre Haute, INThe student pilot's failure to maintain the runway heading and to relinquish the flight controls to the flight instructor when told to do so while landing in gusting, crosswind conditions, which resulted in a runway excursion and impact with runway lighting.NTSB GAA19CA329Accident · No injuriesData collectionFinal reportErcoupe 415 · Lafayette, INThe flight instructor's failure to maintain pitch control and his improper landing flare, which resulted in a hard landing.NTSB CEN19FA148Accident · 2 fatalClass 2 · FieldFinal reportCessna S550 · Greenfield, INThe pilot's failure to fully advance the power levers during the takeoff and initial climb, which led to his failure to maintain sufficient airspeed and resulted in the exceedance of the airplane's critical angle of attack and a subsequent aerodynamic stall.NTSB GAA19CA246Accident · Minor injuriesData collectionFinal reportCessna 182 · Marion, INThe pilot's improper trim setting and his exceedance of the airplane's critical angle of attack during a go-around, which resulted in an aerodynamic stall.NTSB CEN19FA135Accident · Serious injuriesClass 2 · FieldFinal reportPiper PA34 · Anderson, INThe loss of left engine power due to an incorrectly adjusted fuel servo and the airplane's nose up trim which resulted in the airplane steep climb, loss of airspeed, and aerodynamic stall and subsequent impact with terrain.NTSB GAA19CA244Accident · No injuriesData collectionFinal reportCessna A185 · Valparaiso, INThe pilot's improper throttle application and subsequent failure to maintain directional control during the takeoff roll in gusting left crosswind conditions, which resulted in a ground loop.NTSB GAA19CA215Accident · No injuriesData collectionFinal reportKaminskas RTH Jungster 1 · Lebanon, INThe pilot's selection of unsuitable terrain for landing, which resulted in a nose-over.NTSB CEN19FA084Accident · 1 fatalClass 3 · FieldFinal reportPiper PA32R · Goshen, INThe pilot’s failure to maintain adequate altitude for undetermined reasons during a practice circling approach in dark night visual meteorological conditions, which resulted in a collision with power lines.NTSB CEN19LA090Accident · No injuriesClass 2 · LimitedFinal reportBeech 400 · Richmond, INThe flight crew's decision to continue an unstable approach under conditions that exceeded the airplane's landing performance capabilities, which resulted in a runway overrun and impact with terrain.NTSB CEN19FA044Accident · 1 fatalField investigationFinal reportPiper PA24 · Valparaiso, INThe pilot's failure to maintain adequate airspeed during the initial climb after takeoff, which resulted in an exceedance of the airplane's critical angle of attack and a subsequent aerodynamic stall and spin.NTSB CEN19FA036Accident · 3 fatalClass 3 · FieldFinal reportCessna 525 · Memphis, INThe pilot’s inability to regain airplane control after a left roll that began for reasons that could not be determined based on the available evidence.NTSB CEN19FA035Accident · 1 fatalField investigationFinal reportPiper PA 30 · Marion, INThe pilot's exceedance of the airplane's critical angle of attack following a loss of the left engine power shortly after takeoff, which resulted in an aerodynamic stall at an altitude too low for recovery. Contributing to the accident was the loss of left…NTSB WPR19LA011Accident · No injuriesClass 3 · LimitedFinal reportPiper PA32R · Indianapolis, INA total loss of engine power due to displacement of the dual magneto’s internal camshaft, which resulted in the magneto’s inability to produce spark.NTSB ERA19LA022Accident · No injuriesLimited investigationFinal reportPiper PA22 · Brownstown, INThe total loss of engine power for reasons that could not be determined because postaccident examination of the engine revealed no mechanical malfunctions or failures that would have precluded normal operation. Contributing to the outcome was the student…NTSB CEN18LA352Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Rushville, INLoss of engine power due to carburetor icing and the pilot's failure to use carburetor heat in weather conditions conducive to carburetor icing.NTSB CEN18LA319Accident · No injuriesLimited investigationFinal reportBeech 35 · Knox, INThe total loss of engine power for reasons that could not be determined based on the available evidence.NTSB CEN18FA282Accident · 1 fatalField investigationFinal reportFisher Celebrity · Patriot, INAn in-flight separation of the right wing due to upward and rearward bending that led to an overstress fracture. The reason for the upward and rearward bending could not be determined based on the available information.NTSB GAA18CA424Accident · No injuriesData collectionFinal reportBell 206 · New Castle, INThe pilot's failure to ensure that the fill hose was disconnected from the helicopter before takeoff, which resulted in the fill hose striking the tail rotor and the subsequent loss of tail rotor effectiveness. Contributing to the accident was inadequate…NTSB CEN18LA269Accident · Serious injuriesLimited investigationFinal reportBell 47J · Franklin, INA total loss of engine power for reasons that could not be determined based on the available evidence.NTSB CEN18FA258Accident · 1 fatalField investigationFinal reportBell 47G · Arlington, INThe inflight separation of the upper transmission due to the thread failure of transmission housing attachment bolts, which were installed on the helicopter with thread damage from a prior installation.NTSB CEN18TA233Accident · Serious injuriesFinal reportCessna 150F · Ferdinand, INThe pilot's failure to apply carburetor heat in conditions conducive to the accumulation of carburetor icing, which resulted in a total loss of engine power.NTSB CEN18LA174Accident · No injuriesLimited investigationFinal reportCessna 177 · Fort Wayne, INThe failure of the oil cooler due to a defect in the brazed joint, which resulted in a loss of engine power due to oil starvation.NTSB CEN18LA165Accident · Serious injuriesLimited investigationFinal reportPiper PA 34-200 · Valparaiso, INThe pilot receiving instruction’s failure to maintain a safe operating airspeed, which resulted in a loss of airplane control. Contributing to the accident was the flight instructor's failure to monitor the pilot's airspeed control.NTSB GAA18CA277Accident · No injuriesData collectionFinal reportCessna 162 · Waterloo, INThe pilot’s improper landing flare during a soft-field landing and his use of an improper soft-field landing procedure, which resulted in a bounced landing.NTSB CEN18FA132Accident · 2 fatalField investigationFinal reportCessna 150 · Marion, INThe failure of both pilots to see and avoid the other airplane as they converged on intersecting runways. Contributing to the accident was the jet pilot's not monitoring the airport's traffic advisory frequency, known reduced visibility of the intersecting…NTSB GAA18CA195Accident · No injuriesData collectionFinal reportPiper PA24 · Knox, INThe flight instructor’s improper landing flare, which resulted in a hard landing.NTSB CEN18FA107Accident · 3 fatalField investigationFinal reportCessna 441 · Rossville, INAn in-flight loss of control for reasons that could not be determined based on the available evidence.NTSB CEN18FA088Accident · 1 fatalField investigationFinal reportCessna 172F · Williamsport, INThe pilot's mismanagement of fuel, which resulted in fuel exhaustion and descent and collision with trees.NTSB CEN18LA062Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 525A · Michigan City, INThe flight crew's improper decision to land on a snow-covered runway that had insufficient runway distance for the airplane to land with the contamination, which resulted in a runway overrun and impact with obstacles.NTSB CEN18FA053Accident · 3 fatalField investigationFinal reportCessna T210M · Oldenburg, INA total loss of engine power due to the failure of the No. 4 piston, which resulted in an attempted forced landing in dark night conditions and a subsequent in-flight collision with trees and terrain. Contributing to the accident were the pilot's situational…NTSB CEN18LA048Accident · No injuriesLimited investigationFinal reportPiper PA 31-310 · Jeffersonville, INThe right main landing gear’s failure to fully extend for reasons that could not be determined because postaccident testing revealed no mechanical anomalies that would have precluded normal operation.NTSB CEN17LA365Accident · No injuriesLimited investigationFinal reportGaddis Michael Exec 162 F · Plymouth, INA failure of the drive belt for reasons that could not be determined based on the available information.NTSB CEN17LA348Accident · No injuriesLimited investigationFinal reportBeech N35 · South Bend, INThe improperly seated fuel cap, which resulted in an in-flight fuel leak and subsequent total loss of engine power due to fuel starvation.NTSB CEN17LA375Accident · No injuriesLimited investigationFinal reportHiller UH 12A · Griffith, INThe loss of tail rotor thrust due to a failed tail rotor driveshaft, which resulted in a loss of tail rotor control and a hard landing.NTSB CEN17FA334Accident · 1 fatalField investigationFinal reportVans RV-12 · Fishers, INThe pilot's failure to latch the canopy before takeoff, and his failure to maintain pitch control following the in-flight opening of the canopy during the initial climb resulting in a subsequent impact with terrain and ground fire.NTSB CEN17LA318Accident · Minor injuriesLimited investigationFinal reportKnapp Easy Raider · Rochester, 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.