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 WPR09LA411Accident · Serious injuriesLimited investigationFinal reportRobinson R44 · Tonopah, NVThe pilot’s failure to maneuver the helicopter within its performance capabilities while at a low altitude in mountainous terrain and in high density altitude conditions.NTSB WPR09LA408Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Tacoma, WAThe pilot's improper landing flare in crosswind conditions resulting in a gear leg collapse.NTSB WPR09CA416Accident · No injuriesData collectionFinal reportMorgan James E Morgan RV6 · Everett, WAThe pilot’s failure to maintain clearance from objects during taxi. Contributing to the accident was the inadequate marking of the taxiway and obstacles.NTSB WPR09CA415Accident · No injuriesData collectionFinal reportPaul B. Johnson Avid Mark IV · Nampa, IDThe airplane's encounter with tall vegetation that ensnared the landing gear during an off-field precautionary landing.NTSB WPR09CA410Accident · No injuriesData collectionFinal reportPiper PA28 · Glendale, AZThe student pilot's failure to maintain directional control during the landing roll.NTSB ERA09LA473Accident · Minor injuriesLimited investigationFinal reportFlight Design Ctsw · Okeechobee, FLA total loss of engine power during initial climb for undetermined reasons.NTSB ERA09LA469Accident · 1 fatalLimited investigationFinal reportRaytheon 58 · Teterboro, NJThe complete loss of thrust due to the second-in-command’s (SIC) inadvertent feathering of both propellers during a high-speed, low-altitude approach. Contributing to the accident was the pilot-in-command’s inadequate monitoring of the SIC’s performance.…NTSB ENG09WA012Incident · No injuriesForeign investigationBoeing 737 · Launceton, Tasmania, AustraliaThe Australian Transport Safety Bureau (ATSB) reported that on August 21, 2009, a Virgin Blue Boeing 737-800 airplane registered in Australia as VH-VOC, experienced two compressor surges in the left engine, a CFMI CFM56-7, shortly after takeoff from Launceton…NTSB CEN09LA546Accident · No injuriesLimited investigationFinal reportTaylorcraft BCS-65 · Boulder, COA partial loss of engine power during initial climb due to carburetor icing.NTSB WPR09GA407Accident · 1 fatalFinal reportAir Tractor AT-802A · Austin, NVThe pilot’s failure to maintain a stabilized approach prior to the retardant drop and his subsequent failure to release the retardant load, resulting in a stall/mush and collision with terrain.NTSB ERA09LA549Accident · No injuriesLimited investigationFinal reportCessna 172P · Pensacola, FLThe student pilot's improper flare, which resulted in a hard landing.NTSB ERA09LA470Accident · No injuriesLimited investigationFinal reportCessna A188B · McRae, GAA total loss of engine power due to pre-ignition/detonation as a result of a fuel control malfunction.NTSB ANC09CA085Accident · No injuriesData collectionFinal reportCessna 140 · Fairbanks, AKThe pilot's failure to achieve a proper touchdown point, resulting in an overrun and a nose over.NTSB WPR09FA409Accident · 1 fatalField investigationFinal reportStemme S10-VT · Mackay, IDThe pilot's failure to maintain adequate airspeed while maneuvering in terrain-induced turbulent wind conditions, resulting in an inadvertent entry into a stall/spin.NTSB WPR09CA406Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Mesa, AZThe student pilot’s inadequate compensation for the crosswind condition and failure to maintain directional control during landing.NTSB ENG10WA006Incident · No injuriesForeign investigationBoeing 737-236 · Coca, Ecuador, EcuadorOn August 19, 2009, a Boeing 737-236, registration number HC-CFD, experienced a thrust reverser separation from the No. 1 (left) engine, a Pratt & Whitney JT8D-17A turbofan, after touchdown runway 15 and thrust reverser deployment at the Coca - Aeropuerto…NTSB WPR09CA404Accident · No injuriesData collectionFinal reportJabiru J230-SP · Reno, NVThe pilot’s failure to maintain directional control throughout the takeoff roll.NTSB ERA09LA468Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Mount Holly, NJA loss of directional control during landing for undetermined reasons.NTSB CEN09LA534Accident · No injuriesLimited investigationFinal reportWSK PZL Mielec M-18A · Audubon, IAA loss of engine power due to failure of the compressor turbine resulting from exposure to elevated operating temperatures for undetermined reasons.NTSB WPR09FA400Accident · 2 fatalField investigationFinal reportPiper PA-24 · Prescott, AZThe pilot’s failure to maintain an adequate airspeed while maneuvering to return to the runway at a high density altitude, which resulted in an aerodynamic stall.NTSB WPR09CA403Accident · No injuriesData collectionFinal reportRockwell 690 · Wenatchee, WAThe pilot’s failure to maintain situational awareness, and thus clearance from objects, while operating at low altitude.NTSB ERA09LA467Accident · No injuriesLimited investigationFinal reportCessna 140A · White Plains, NYThe failure of the right main landing gear due to a preexisting crack adjacent to a weld line.NTSB ERA09LA464Accident · No injuriesLimited investigationFinal reportEurocopter Deutschland EC-145 · North Captiva Island, FLThe pilot's failure to arrest the helicopter's descent, which resulted in controlled flight into terrain.NTSB ERA09CA465Accident · No injuriesData collectionFinal reportAeronca 7AC · Finleyville, PAThe pilot’s failure to maintain directional control during landing.NTSB CEN09CA539Accident · No injuriesData collectionFinal reportDunn David RAF 2000 C · Lakeville, MNThe pilot's failure to maintain control of the aircraft during the landing flare.NTSB CEN09CA535Accident · No injuriesData collectionFinal reportAir Tractor AT-301 · Leland, ILA total loss of engine power in flight due to a loss of engine oil as a result of the separation of the propeller hub components for undetermined reasons.NTSB CEN09CA533Accident · No injuriesData collectionFinal reportAir Tractor AT-502B · Whittemore, IAThe pilot's lack of preflight planning and remedial action with resulted in the airplane's inability to climb out of ground effect.NTSB WPR09FA398Accident · 2 fatalField investigationFinal reportCessna 152 · Hesperia, CAThe pilot's failure to maintain adequate airspeed while maneuvering in the traffic pattern, which resulted in an aerodynamic stall/spin. Also causal was the failure of the left magneto due to improper assembly of the drive gear during installation on the…NTSB ERA09LA471Accident · No injuriesLimited investigationFinal reportPiper PA-46-350P · Sanford, FLThe fatigue cracking at the point the nose landing gear actuator attaches to the mount resulting in separation of the actuator and partial collapse of the nose landing gear. Contributing to the accident was the lack of specific inspection guidance for…NTSB CEN09LA526Accident · No injuriesLimited investigationFinal reportThrush S2R-T660 · Worthington, MNA fatigue failure of the elevator push-pull rod which resulted in the pilot's inability to control the aircraft's pitch attitude while landing.NTSB CEN09LA523Accident · 2 fatalLimited investigationFinal reportFrom Here To There PDQ RV-8 · Tea, SDThe pilot's failure to maintain control of the airplane during recovery from an aerobatic maneuver.NTSB CEN09CA532Accident · Serious injuriesData collectionFinal reportPiper PA-28-161 · Washington, IAA loss of engine power due to carburetor icing as a result of the pilot's failure to use carburetor heat in conditions that were conducive to carburetor icing.NTSB CEN09CA531Accident · Serious injuriesData collectionFinal reportFisher Michael H T-BIRD II · Dundee, OHA total loss of engine power due to the failure of the outer crankshaft seal.NTSB CEN09CA530Accident · No injuriesData collectionFinal reportCessna 172 · Centennial, COThe pilot's failure to maintain directional control of the airplane during the landing flare in crosswind conditions.NTSB CEN09CA528Accident · No injuriesData collectionFinal reportMorse, Frank L. Kitfox · Crawford, COThe pilot's continued flight into a severe downdraft at low altitude after encountering tailwind over the area.NTSB ANC09LA083Accident · No injuriesLimited investigationFinal reportCessna 185 · McCarthy, AKThe separation of the right main landing gear wheel from the airplane during landing for undetermined reasons, which resulted in an inability to control the airplane.NTSB WPR09CA399Accident · No injuriesData collectionFinal reportAeronca 11CC · El Cajon, CAThe pilot's inadequate compensation for the crosswind conditions and failure to maintain directional control while landing.NTSB ERA09TA466Accident · No injuriesFinal reportCessna 180 · Spartanburg, SCThe Cessna pilot's inadequate visual lookout.NTSB ERA09CA463Accident · No injuriesData collectionFinal reportAmerican Legend AL3C · Warrenton, VAThe pilot's improper application of brakes during the landing rollout.NTSB CEN09LA527Accident · 1 fatalLimited investigationFinal reportAir Tractor AT-802A · Corning, IAThe in-flight loss of control due to the pilot's impairment as a result of hypoxia. Contributing to the accident was the pilot's decision to operate the unpressurized airplane at an altitude requiring supplemental oxygen without having any oxygen available.NTSB CEN09LA525Accident · Serious injuriesLimited investigationFinal reportCessna 182 · Caddo Mills, TXThe failure of the operator to ensure that the airplane engine was shutdown during passenger unloading and the lack of adequate supervision of the passenger by the pilot and ground crewmember.NTSB CEN09CA548Accident · No injuriesData collectionFinal reportPiper PA-15 · Plainwell, MIA loss of control on takeoff for undetermined reasons.NTSB CEN09WA524Accident · 2 fatalForeign investigationBeech 99 · Évora, PortugalUnder the jurisdiction and control of the Portuguese government.NTSB ANC09CA082Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Kaktovik, AKThe pilot's selection of unsuitable terrain for takeoff, which resulted in a loss of control and collision with terrain.NTSB WPR09LA396Accident · Minor injuriesLimited investigationFinal reportBeech A60 · Minidoka, IDA loss of engine power due to fuel exhaustion as a result of the pilot's inadequate fuel planning.NTSB WPR09GA397Accident · Serious injuriesFinal reportEurocopter AS 350 B2 · Lancaster, CAThe pilots’ decision to conduct a practice autorotation at low altitude in high density altitude conditions and their failure to attain and maintain an appropriate descent rate. Contributing to the accident was the high density altitude and the pilots’…NTSB WPR09CA405Accident · No injuriesData collectionFinal reportAeronca 7DC-CONV · Winnemucca, NVThe pilot's failure to maintain directional control during landing.NTSB WPR09CA393Accident · No injuriesData collectionFinal reportGrumman Acft ENG Cor-Schweizer G-164B · Westley, CAThe pilot’s inadequate preflight planning and preparation, and his decision to operate the airplane well in excess of its maximum gross weight.NTSB CEN09CA520Accident · No injuriesData collectionFinal reportGrahn J/Grahn G Pitts S2S · Rifle, COThe pilot's excessive landing speed and subsequent excessive brake application which resulted in a loss of control and impact with an airport sign.NTSB WPR09LA395Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Glendale, AZA loss of engine power for undetermined reasons.