NTSB investigations
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 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 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 ANC05LA143Accident · No injuriesLimited investigationFinal reportCessna 180C · Igiugig, AKThe failure of the airplane's starter to disengage, which resulted in an overheated starter, smoke in the cockpit, and an emergency landing. A factor associated with the accident was soft terrain encountered during the emergency landing.NTSB ANC05LA142Accident · No injuriesLimited investigationFinal reportCessna 185E · Pilot Point, AKThe pilot's misjudged landing flare, which resulted in a hard landing and an overload failure of the main landing gear during the landing touchdown.NTSB SEA05LA192Accident · No injuriesLimited investigationFinal reportNorth American AT-6D · Chehalis, WAThe pilot's failure to follow the checklist to switch to the fullest fuel tank prior to departure which resulted in fuel starvation and a loss of engine power during the initial takeoff climb. Subsequently, the aircraft landed hard damaging the landing gear…NTSB DFW05CA234Accident · No injuriesData collectionFinal reportCessna 152 · Galveston, TXThe pilot's improper in-flight planning and decisions, which resulted in fuel exhaustion. A contributing factor was the lack of suitable terrain for the forced landing.NTSB DEN05CA138Accident · No injuriesData collectionFinal reportRobinson R44 II · Jackson, WYthe pilot's failure to maintain aircraft control during initial takeoff climb resulting in an uncontrolled descent and impact with terrain. A contributing factor was the pilot's encounter in settling with power.NTSB DEN05CA136Accident · Minor injuriesData collectionFinal reportCessna T207A · Telluride, COthe pilot's improper in-flight planning/decision and failure to maintain aircraft control. Contributing factors were the pilot's failure to maintain airspeed which resulted in an inadvertent stall, and the rising terrain and encounter with downdrafts.NTSB CHI05LA261Accident · 1 fatalLimited investigationFinal reportPiper PA-28-235 · Faulkton, SDThe pilot's failure to maintain control of the airplane due to spatial disorientation during initial climb after takeoff into night instrument meteorological conditions. Factors were the fog and the dark night.NTSB CHI05CA262Accident · No injuriesData collectionFinal reportCessna 310Q · Boscobel, WIThe pilot's misjudged distance/altitude which resulted in an undershoot. A related factor was the pilot's diverted attention due to the open cabin door.NTSB CHI05CA259Accident · Minor injuriesData collectionFinal reportDixon RV-4 · Grafton, ILThe loss of engine power due to contamination of the fuel system, gascolator and carburetor inlet screen. A factor to the accident was the soybean crop.NTSB MIA05WA154Accident · 1 fatalForeign investigationBeech BE-58 · Exuma Cay, BahamasNTSB LAX05CA291Accident · No injuriesData collectionFinal reportRobinson R22 · Santa Clarita, CAthe pilot's improper use of the collective control while attempting to free the right skid, which induced a dynamic rollover.NTSB LAX05FA290Accident · 2 fatalField investigationFinal reportCessna 172RG · Avalon, CAan in-flight loss of control for undetermined reasons.NTSB ENG06WA011Accident · 2 fatalForeign investigationRobinson R44 · Slieve Aughty Mountains, Co Galway, Ireland, IrelandNTSB DFW05WA232Accident · 2 fatalForeign investigationCessna 152 · Guadalajara, MexicoNTSB DFW05LA239Accident · Minor injuriesLimited investigationFinal reportBell 206B · New Orleans, LAThe pilot's failure to maintain directional control after encountering a loss of tail rotor effectiveness. A contributing factor was the lack of suitable terrain.NTSB DEN05CA135Accident · Minor injuriesData collectionFinal reportAviat A-1B · Sheridan, WYpilot's failure to maintain aircraft control during the aborted landing. A contributing factor was the pilot's failure to maintain airspeed which resulted in an inadvertent stall.NTSB CHI05LA257Accident · 1 fatalLimited investigationFinal reportHildebrant Rutan Defiant · Bloomfield, INThe pilot's inadequate preflight planning which resulted in the airplane overrunning the end of the runway during the aborted takeoff. A factor to the accident was the pilot's lack of familiarity with the airplane and the corn crop.NTSB CHI05CA258Accident · No injuriesData collectionFinal reportPiper PA-44-180 · Fertile, MNThe flightcrew's failure to extend the landing gear prior to touchdown, and the flight instructor's inadequate supervision of the flight.NTSB CHI05CA256Accident · No injuriesData collectionFinal reportBoeing A75N1 · Ellisville, ILThe loss of engine power due to the failure of the number four connecting rod. A factor to the accident was the soybean crop.NTSB ANC05CA137Accident · No injuriesData collectionFinal reportdeHavilland DHC-2 · Igiugig, AKThe pilot's delay in aborting the takeoff run when he was unable to lift one float off the water, which resulted in a subsequent collision with terrain. A factor contributing to the accident was a river bank.NTSB IAD05LA133Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · Babylon, NYA broken piston and exhaust valve tappet which resulted in a total loss of engine power, and a forced landing to unsuitable terrain. A contributing factor was the failure of the operator to overhaul the engine at the manufacturer's recommended interval.NTSB DFW05MA230Accident · Serious injuriesMajor investigationFinal reportSikorsky S76 · Gulf of Mexico, TXThe pilots' delayed response to the No. 1 engine fire warning and the loss of power to both engines, which occurred for undetermined reasons. The pilots' delayed response was most likely due to stress and fatigue. Contributing to the delay of the initiation…NTSB DFW05CA206Accident · No injuriesData collectionFinal reportCessna 182T · Houston, TXThe gear-up landing as result of the separation of the hydraulic line in the landing gear extension system.NTSB ATL05CA158Accident · Minor injuriesData collectionFinal reportChristen Industries S-2B · Deeherd, TNThe pilots inadequate preflight of the fuel tank resulting in a total loss of engine power in cruise flight, forced landing, and nose over on landing roll out.NTSB ANC05CA139Accident · No injuriesData collectionFinal reportPiper PA-18 · Fairbanks, AKThe pilot's failure to maintain adequate airspeed during takeoff initial climb, which resulted in an inadvertent stall/mush, and subsequent in-flight collision with trees. A factor contributing to the accident was a tailwind.NTSB ANC05CA138Accident · No injuriesData collectionFinal reportCessna 180 · Aniak, AKThe pilot's selection of unsuitable terrain for landing, which resulted in a collision with brush during the landing flare. A factor contributing to the accident was high vegetation.NTSB SEA05CA186Accident · No injuriesData collectionFinal reportPiper PA-22 (20) · McCall, IDThe pilot's failure to maintain airspeed during takeoff. A wire fence was a factor in the accident.NTSB LAX05LA289Accident · Serious injuriesLimited investigationFinal reportBell 206B · Long Beach, CAthe pilot's decision not to release the banner when it became entangled on itself, which resulted in the banner tow rope becoming ensnarled with the tail rotor system.NTSB LAX05CA297Accident · No injuriesData collectionFinal reportBeech C23 · Jiggs, NVthe pilot's encounter with a downdraft.NTSB IAD05CA131Accident · Minor injuriesData collectionFinal reportCirrus Design SR22 · Lincoln Park, NJThe pilot's failure to obtain the proper touchdown point during landing which resulted in a runway overrun. A factor was the pilot's misjudgment of speed/distance during the approach.NTSB DFW05LA229Accident · 1 fatalLimited investigationFinal reportCessna A188B · Blytheville, ARThe pilot's failure to maintain control of the aircraft for undetermined reasons.NTSB DCA05RA096Accident · 145 fatalForeign investigationBoeing B737-200 · Medan, IndonesiaNTSB SEA05WA190Accident · 1 fatalForeign investigationHughes 300AG · Tallard, FranceNTSB SEA05LA187Accident · No injuriesLimited investigationFinal reportCessna 182E · Toutle, WAThe loss of engine power as a result of fuel exhaustion due to the pilot's failure to properly secure the fuel caps during his self-servicing and (improperly) preflighting the airplane. A contributing factor was the utility pole.NTSB LAX05CA299Accident · No injuriesData collectionFinal reportCessna 172S · San Manuel, AZThe pilot's misjudged flare during a touch-and-go landing.NTSB IAD05LA147Accident · Minor injuriesLimited investigationFinal reportHanson VariEze · New Cumberland, PAThe owner/builder's inadequate fuel tank inspection during construction, which resulted in fuel contamination and subsequent fuel starvation to the engine.NTSB CHI05CA253Accident · No injuriesData collectionFinal reportRobinson R22 Beta · Rockton, ILThe pilot's excessive descent rate on approach for landing and the settling with power condition subsequently encountered. Contributing factors were the pilot's failure to reduce the descent rate prior to entering the settling with power condition and his…NTSB ATL05CA157Accident · Minor injuriesData collectionFinal reportCessna 172F · Haleyville, ALThe pilots inadequate preflight of the fuel tank resulting in a total loss of engine power in cruise flight due to fuel exhaustion, resulting in a forced landing, and nose over on landing roll out.NTSB ANC05CA145Accident · No injuriesData collectionFinal reportCessna 180 · McGrath, AKThe pilot's failure to maintain control of the airplane during the landing roll, which resulted in a nose over.NTSB NYC05FA140Accident · 1 fatalField investigationFinal reportCessna 177A · S. Hackensack, NJThe pilot's inadequate preflight planning, which resulted in fuel exhaustion and subsequent loss of engine power. A factor in the accident was the pilot's impairment from prescription medication.NTSB LAX05LA288Accident · Minor injuriesLimited investigationFinal reportGoodlett Safari · Trona, CAthe in-flight fatigue failure of a control system connecting rod, which resulted in a loss of helicopter control.NTSB DEN05CA134Accident · No injuriesData collectionFinal reportEclipse HXB · Albuquerque, NMthe pilot's failure to extend the landing gear prior to landing. A contributing factor was the pilot's failure to complete the before landing checklist.NTSB CHI05CA267Accident · No injuriesData collectionFinal reportWest Revolution Mini 500 · Ida, MIThe pilot's abrupt (improper) control action which resulted in the main rotor contacting the tail boom. Contributing factors were the false indication provided by the engine tachometer, the pilot's decision to immediately initiate an autorotation instead of…NTSB ANC05CA134Accident · No injuriesData collectionFinal reportChampion 7KCAB · Fairbanks, AKThe pilot's selection of unsuitable terrain for landing, which resulted in a nose over during the landing roll. A factor contributing to the accident was a depression/ditch in the landing surface.NTSB SEA05LA189Accident · No injuriesLimited investigationFinal reportBallhagen/Shyrock Q-2 · Kalispell, MTThe pilot/owner's improper setting of the engine's valve clearance, leading to the failure of the exhaust valves to fully close and a total loss of power while on a VFR downwind, and the pilot/owner's failure to maintain sufficient airspeed as he tried to…NTSB SEA05LA188Accident · 1 fatalLimited investigationFinal reportKirner Fisher FP404 · Prineville, ORThe design stress limits of the aircraft were exceeded resulting in a wing separation while the pilot was accomplishing maneuvers of hard banking turns, spins and steep descents.NTSB LAX05LA286Accident · 1 fatalLimited investigationFinal reportCessna 172 · Yuma, AZthe pilot's failure to maintain an adequate airspeed on short final, which resulted in an inadvertent stall.NTSB IAD05LA130Accident · No injuriesLimited investigationFinal reportCessna 172S · Kutztown, PAThe pilot's failure to attain a proper touchdown point as a result of the airplane's excessive airspeed. A factor was the partial loss of engine power due to a seized exhaust valve.NTSB DEN05LA131Accident · Minor injuriesLimited investigationFinal reportAerospatiale SA315B · Duchesne, UTthe loss of control during external load operations for undetermined reasons.NTSB ANC05WA135Accident · No injuriesForeign investigationPiper PA-31-400 · Meinerzhagen, Germany