NTSB investigations, IN
180,616 investigations by the National Transportation Safety Board since 1962: 174,594 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' 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' 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 CHI92LA072Accident · No injuriesLimited investigationFinal reportBeech A36 · Griffith, INPremature gear retraction during takeoff roll by the pilot.NTSB CHI92IA068Incident · No injuriesIncident investigationFinal reportBritish Aerospace BAE-ATP · Fort Wayne, INFailure of company maintenance personnel to maintain the airplane in accordance with existing service bulletins.NTSB CHI92LA065Accident · No injuriesLimited investigationFinal reportCessna 172 · Greencastle, INThe worn centering locking lug on the nose gear assembly.NTSB CHI92LA064Accident · Serious injuriesLimited investigationFinal reportCessna 182K · Huntington, INPilot factor in that he failed to maintain flying speed in a turn which resulted in an inadvertent stall. Factors related to the accident are; icing conditions, hazardous weather advisory disregarded, flight into known adverse weather, and overconfidence in…NTSB CHI92LA058Accident · No injuriesLimited investigationFinal reportCessna 150 · Charlestown, INFuel exhaustion. Factors related to the accident were inadequate maintenance of the airplane and the pilot's decision to fly an airplane with known mechanical deficiencies.NTSB CHI92LA048Accident · 1 fatalLimited investigationFinal reportBeech A36 · Rensselaer, INThe pilot's improper aircraft handling which resulted in an inadvertent stall and descent. Factors related to the accident were the obscuration & icing conditions.NTSB CHI92LA056Accident · No injuriesLimited investigationFinal reportCessna 177 · Elkhart, INThe pilot in command's failure to use carburetor heat. A factor to the accident was the carburetor icing conditions.NTSB CHI92LA045Accident · No injuriesLimited investigationFinal reportPiper PA-15 · Indianapolis, INRemedial action was not performed by the cfi/pic. A factor related to the accident was directional control was not maintained by the student pilot.NTSB CHI92LA017Accident · No injuriesLimited investigationFinal reportMcdonnell Douglas MD369D · Beech Grove, INImproper installation of the flight control linkage during maintenance. Complacency and inadequate inspection of the helicopter by maintenance personnel and the pilot are factors in the accident.NTSB CHI92LA096Accident · Serious injuriesLimited investigationFinal reportCameron N120 · Goshen, INAn improper touchdown by the pilot in command.NTSB CHI92FA013Accident · 2 fatalField investigationFinal reportPiper PA28-140 · Lafayette, INFailure of the pilot to compensate for wind conditions during initial climb. Factors associated with the accident are crosswind conditions and a dark night light condition.NTSB CHI92LA016Accident · Serious injuriesLimited investigationFinal reportAerostar RX-8 · Warsaw, INPilot's delayed inflight planning/decision to land.NTSB CHI92LA010Accident · No injuriesLimited investigationFinal reportMooney M20K · Knox, INThe overload failure of the #2 cylinder connecting rod. Contributing to the accident was the night light conditions and the pilot's inability to reach a suitable landing area.NTSB CHI92LA004Accident · No injuriesLimited investigationFinal reportBeech 95 · Elkhart, INThe inadequate amount of hydraulic fluid present in the normal brake system.NTSB CHI91LA295Accident · No injuriesLimited investigationFinal reportCessna 152 · Marion, INFailure of the pilot to maintain directional control during the takeoff ground run from a touch-and-go landing.NTSB CHI91LA256Accident · Serious injuriesLimited investigationFinal reportLuscombe 8E · Valparaiso, INThe pilot in command's failure to maintain airspeed. A factor contributing was improper maintenance (design change) performed by an unqualified person (pilot in command).NTSB CHI91LA251Accident · Minor injuriesLimited investigationFinal reportStinson 108-1 · Elwood, INA premature lift-off which resulted in a mush/stall. A factor related to the accident was lack of total experience in type of operation.NTSB CHI91LA245Accident · Serious injuriesLimited investigationFinal reportHiller 1345 · Michigan City, INFuel exhaustion due the pilot's delay in refueling. Factors related to the accident were pressure induced by others (passenger), and the absence of suitable terrain.NTSB CHI91LA226Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · Lafayette, INEngine failure due to fuel exhaustion and refueling not performed by the cfi/pic.NTSB CHI91FA228Accident · 2 fatalField investigationFinal reportRobinson R 22B · Carmel, INThe pilot's delaying remedial action. Factors in the accident were the pilot's failure to attain adequate rotor RPM for takeoff, failure to abort takeoff and lack of total experience in helicopters.NTSB CHI91LA221Accident · No injuriesLimited investigationFinal reportCessna 150M · Merrillville, INImproper pre-flight planning and preparation by the pilot-in-command. Factors related to this accident were the pilot-in-commands's inattentiveness concerning the refueling of his airplane, and inadequate fuel supply, inattentive ground personnel, and…NTSB CHI91DEX04Accident · Minor injuriesFinal reportWilbur D. Batman Challenger II · Lebanon, INFailure to maintain stall airspeed while executing a forced landing. A factor related to the accident is failure of the engine starter clutch.NTSB CHI91DEX03Accident · No injuriesFinal reportCessna 320F · Washington, INExceeding the aircraft's proper descent rate by the pilot in command. Factors related to the accident were inoperative runway edge lights, proper alignment not attained, improperly planned approach, and inadequate facility maintenance.NTSB CHI91LA182Accident · No injuriesLimited investigationFinal reportCessna 310L · Fort Wayne, INThe improper installation of a bearing by maintenance personnel.NTSB CHI91LA173Accident · Serious injuriesLimited investigationFinal reportGulfstream American AA1A · Evansville, INThe failure by maintenance personnel to identify the proper replacement cylinder.NTSB CHI91LA153Accident · No injuriesLimited investigationFinal reportCessna 177 · Decatur, INFailure to obtain airspeed for positive lift off and climb. Factors related to the accident were a grass/sod runway and a high density altitude.NTSB CHI91LA129Accident · Serious injuriesLimited investigationFinal reportCessna 172G · Griffith, INContaminated fuel in the carburetor, and inadequate inspection/maintenance of the airplane by the pilot in command.NTSB CHI91LA124Accident · Minor injuriesLimited investigationFinal reportCessna C172N · North Liberty, INThe pilot's inadvertent touchdown and inadequate remedial action. Related factors are the low pass maneuver, and the soft terrain.NTSB CHI91LA101Accident · No injuriesLimited investigationFinal reportCessna T210N · Elwood, INThe pilot's improper use of the fuel selector which resulted in fuel starvation. A related factor was: soft terrain in the emergency landing area.NTSB CHI91DEX02Accident · No injuriesFinal reportHagg Starduster TOO · Shelbyville, INThe pilot's inadequate preflight planning/preparation, not refueling the aircraft before taking off on this flight, and inaccurate fuel consumption calculations. A factor related to the accident is the unsuitable terrain selected by the pilot for a forced…NTSB CHI91LA086Accident · No injuriesLimited investigationFinal reportBeech 200 · Indianapolis, INSeparation of the aft, upper, accessory case cowl assembly from the airplane, and inadequate airframe equipment provided by the manufacturer.NTSB CHI91LA083Accident · Serious injuriesLimited investigationFinal reportCessna R182 · Indianapolis, INVisual outlook was not possible and aircraft directional control was not maintained by the pilot. Factors related to the accident were dense fog, early dawn light conditions, poor judgement and over confidence in personal ability by the pilot and trees in the…NTSB CHI91LA082Accident · No injuriesLimited investigationFinal reportCessna 170B · Rochester, INThe pilot-in-command's inadequate compensation for wind conditions. A factor contributing to the accident was the crosswind.NTSB CHI91LA087Accident · Serious injuriesLimited investigationFinal reportBoeing 727-200 · Indianapolis, INThe pilot's failure to use proper procedures and the improper use of the throttles.NTSB CHI91LA064Accident · Minor injuriesLimited investigationFinal reportCessna 320E · Elkhart, INA fractured landing gear retraction assembly component and the pilot's improper emergency procedure.NTSB CHI91LA048Accident · No injuriesLimited investigationFinal reportHughes 269A · Sellersburg, INA pilot induced loss of engine power by inadvertent deactivation of the fuel mixture control.NTSB CHI91DEX01Accident · Minor injuriesFinal reportCessna 210G · Indianapolis, INInadequate maintenance and inspection of the airplane resulting in an engine power loss due to water and fuel contamination. A contributing factor was the dark night.NTSB CHI91LA029Accident · No injuriesLimited investigationFinal reportCessna 152 · Kokomo, INThe student pilot's improper recovery from a bounced landing, resulting inadvertent porpoising.NTSB CHI91LA018Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Greenfield, INA stall/spin encountered due to an improper go-around.NTSB CHI91FA011Accident · 3 fatalField investigationFinal reportCessna 172P · Fort Wayne, INThe failure of the pilot to maintain an airspeed above stalling speed. Factors associated with the accident are premature rotation and the pilot's lack of recent total experience.NTSB CHI90LA277Accident · 1 fatalLimited investigationFinal reportNavion L-17A · Fort Wayne, INPoor judgement of the pilot due to impairment from consumption of alcohol and use of a drug, and his failure to maintain proper altitude/clearance above wooded terrain. Darkness was a related factor.NTSB CHI90LA272Accident · Minor injuriesLimited investigationFinal reportCessna A150L · Terre Haute, INAn undetermined loss of engine power.NTSB CHI90LA269Accident · No injuriesLimited investigationFinal reportCessna 152 · Fort Wayne, INThe failure of the pilot of the accident airplane to maintain sufficient speed for flight. The pilots lack of total experience and the crosswinds that were present during the approach and the attempted go-around are contributing factors to the accident.NTSB CHI90LA268Accident · Minor injuriesLimited investigationFinal reportCessna 172F · Huntington, INThe student pilot's improper preflight planning ensuring sufficient fuel for the intended flight.NTSB CHI90LA279Accident · No injuriesLimited investigationFinal reportCessna 177B · Kokomo, INExceeding the design stress limits of the aircraft while recovering from a loss of control in flight due to spatial disorientation. Factors related to the accident were delayed remedial action and inadequate supervision of an inexperienced pilot by the…NTSB CHI90LA253Accident · No injuriesLimited investigationFinal reportPiper PA25-235 · Logansport, INThe engine failed due to fuel exhaustion. The presence of standing corn in the touchdown area was a factor.NTSB CHI90LA251Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Elwood, INThe pilot's failure to abort takeoff.NTSB CHI90LA248Accident · No injuriesLimited investigationFinal reportCessna 172G · Bloomington, INThe pilot's failure to compensate for wind conditions and maintain directional control. The crosswind was a factor.NTSB CHI90DEX02Accident · No injuriesFinal reportJohnson Quickie 299 · Delphi, INPilot/mechanic's improper installation of the rudder cable turnbuckles.NTSB CHI90LA229Accident · No injuriesLimited investigationFinal reportCessna U206A · Fishers, INPilot-in-command's failure to accomplish a recovery from a bounced landing which resulted in a porpoise and collapse of the nose gear.