NTSB investigations
180,641 investigations by the National Transportation Safety Board since 1962: 174,620 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 DCA11WA016Incident · No injuriesForeign investigationAirbus A300 · East Midlands, United KingdomOn January 10, 2011, at 2150 UTC, an Air Atlanta Icelandic Airbus A300 B4-622R, registered in Iceland as TF-ELK, experienced a tailstrike while attempting to land at East Midlands Airport (EGNX), United Kingdom. The flightcrew performed a go-around and…NTSB CEN11WA151Accident · 1 fatalForeign investigationCirrus Design SR20 · Santiago Atitlán, GuatemalaNTSB WPR11LA119Accident · No injuriesLimited investigationFinal reportCzech Sportplanes Sro Dynamic · Palm Springs, CAInadvertent opening of the airplane canopy during the landing approach in a downdraft, which resulted in a rapid descent and hard landing.NTSB WPR11LA095Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Lopez, WAA loss of engine power during initial climb for undetermined reasons.NTSB WPR11LA092Accident · No injuriesLimited investigationFinal reportCessna 310C · Lancaster, CAThe pilot did not maintain an appropriate descent profile during the approach. Contributing to the accident was that the pilot did not follow checklist procedures.NTSB WPR11FA093Accident · No injuriesField investigationFinal reportPiper PA46-500TP · Phoenix, AZThe pilot did not maintain directional control during the landing roll. Contributing to the accident was low nosewheel tire pressure.NTSB ERA11WA111Accident · 1 fatalForeign investigationAir Tractor AT802 · Santa Juana, ChileOn January 9, 2011, at 1930 universal coordinated time, an Air Tractor AT-802, Spanish registration EC-IOE, registered to FAASA Group Aerodromo Sebastian Almagro Ctra, operated by FAASA Chile Servicios Aeros LTDA, collided with trees near Santa Juana, Chile,…NTSB DCA11WA069Accident · No injuriesForeign investigationBoeing 727 · Urmia, IranOn January 9, 2011, an Iran Air Boeing B727-200, registration EP-IRP, crashed during missed approach to Orumiyeh Airport (OITR), Urmia, Iran. Of the 105 passengers and crew onboard, 78 were fataly injured and 27 received serious injuries. The airplane was…NTSB CEN11FA150Accident · 2 fatalField investigationFinal reportPiper PA 46-350P · Westcliffe, COThe pilot's loss of control following an encounter with moderate to severe weather.NTSB WPR11FA090Accident · 2 fatalField investigationFinal reportBeech S35 · Chester, CAThe pilot's loss of control while maneuvering to land, most likely due to spatial disorientation.NTSB WPR11CA091Accident · No injuriesData collectionFinal reportMaule M-4-180V · Elko, NVThe pilot's failure to maintain directional control of the airplane during landing.NTSB ERA11WA113Accident · 5 fatalForeign investigationPartenavia P68 · Cojedes, VenezuelaOn January 7, 2011, at 2045 universal coordinated time, a Partenavia P68C, Venezuelan registration YV1303, was destroyed after it impacted terrain during the en route phase of flight, near Cojedes, Venezuela. The pilot and four passengers were fatally…NTSB CEN11WA159Incident · Minor injuriesForeign investigationBeech B200 · Montpellier, FranceThe accident investigation is under the jurisdiction and control of the French government. This report is for informational purposes only and contains only information released by or obtained from the French government or Bureau d’Enquêtes et d’Analyses.…NTSB ERA11IA110Incident · No injuriesIncident investigationFinal reportMooney M20E · St. Petersburg, FLAn inadequately maintained interior cockpit boot, which allowed a flashlight to fall through and subsequently jam the airplane's flight controls. Contributing to the incident was a lack of emphasis by government, industry, and advocacy groups that the…NTSB ERA11FA107Accident · 1 fatalField investigationFinal reportBeech 58P · Birmingham, ALThe pilot's failure to maintain control of the airplane during an instrument approach due to spatial disorientation.NTSB ERA11CA109Accident · No injuriesData collectionFinal reportPiper PA-28-235 · Lancaster, SCThe pilot's failure to maintain directional control during an attempted go-around maneuver after landing.NTSB ERA11CA108Accident · No injuriesData collectionFinal reportPiper PA-22-150 · Thomaston, GAThe mechanic's failure to install a cotter retaining pin in the throttle arm retaining nut resulting in excessive throttle play and loss of engine power control.NTSB CEN11FA144Accident · Minor injuriesField investigationFinal reportGates Learjet 35A · Springfield, ILThe pilot’s decision to conduct an instrument approach in icing conditions without the anti-ice system activated, contrary to the airplane flight manual guidance, which resulted in an inadvertent aerodynamic stall due to an in-flight accumulation of airframe…NTSB ANC11LA009Accident · No injuriesLimited investigationFinal reportCessna 208B · Kipnuk, AKThe pilot’s decision to land long on the icy snow-covered runway, resulting in a runway excursion and collision with terrain.NTSB CEN11FA141Accident · 2 fatalField investigationFinal reportColumbia Aircraft Mfg LC41-550FG · Midlothian, TXThe engine's loss of power during takeoff for reasons that could not be determined because no engine anomalies were discovered during the postaccident examination.NTSB CEN11CA147Accident · Minor injuriesData collectionFinal reportPegasus 503 Sport · Cambridge, OHThe pilot's failure to maintain clearance from trees and terrain during the landing approach.NTSB WPR11CA088Accident · No injuriesData collectionFinal reportFerkin Kitfox IV · Homedale, IDThe pilot's inadequate compensation for the snow-covered terrain during the takeoff ground roll, which resulted in a nose-over.NTSB WPR11CA085Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Wickenburg, AZThe student pilot's failure to maintain clearance between the airplane's right wing and the pole.NTSB CEN11LA138Accident · 1 fatalLimited investigationFinal reportCessna 172H · Walnut Grove, MOThe pilot's loss of control for undetermined reasons. Contributing to the accident was the pilot's fatigue.NTSB ANC11LA008Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-300 · Platinum, AKThe pilot's misidentification of the airport's active runway, resulting in an off-runway landing and collision with a ditch/berm.NTSB ERA11WA126Accident · 1 fatalForeign investigationPiper · Corupa, BrazilOn January 03, 2011, at 1200 coordinated universal time (10:00 local time), a Piper PA-25-260, Brazilian registration PT-DJS, incurred substantial damage when it impacted terrain for unknown reasons near, Corupa, Santa Catarina, Brazil,. The pilot was fatally…NTSB ERA11LA104Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-161 · Benton, PAThe pilot's failure to maintain clearance from terrain during the night flight.NTSB DCA11FA050Accident · No injuriesField investigationFinal reportBoeing 737-823 · Los Angeles, CAthe early rotation of the airplane to an angle at which the fuselage contacted the runway. Contributing to early rotation was the Captain’s reaction to the erroneous V1 automated callout, likely assuming that the airplane was at or close to the correct Vr at…NTSB ANC11LA007Accident · No injuriesLimited investigationFinal reportBeech E18S-9700 · New Stuyahok, AKThe pilot's misjudgment of the runway surface condition, resulting in an aborted landing and collision with rising terrain during the ensuing takeoff attempt.NTSB WPR11TA087Accident · No injuriesFinal reportPiper PA-18-180 · Shoshoni, WYA total loss of engine power for undetermined reasons.NTSB CEN11LA142Accident · No injuriesLimited investigationFinal reportAmerican Legend AL3 · McKinney, TXThe pilot's loss of directional control during landing.NTSB CEN11CA152Accident · No injuriesData collectionFinal reportEurocopter Deutschland MBB-BK 117 C-2 · Albert Lea, MNThe pilot's inadequate preflight inspection of the engine cowling latches prior the flight, which resulted in the cowling door opening in-flight and striking the main rotor blades.NTSB CEN11CA143Accident · No injuriesData collectionFinal reportRardin William I Kitfox III · Carlisle, ARFailure of the left main landing gear strut due to a pre-existing crack in the weld joint.NTSB CEN11CA137Accident · No injuriesData collectionFinal reportBellanca 1419 · Clovis, NMThe pilot's failure to maintain directional control of the airplane during landing.NTSB WPR11CA086Accident · No injuriesData collectionFinal reportGiorgio Anthony J RV4 · Torrance, CAThe pilot's inadequate landing flare that resulted in a hard landing and a ground loop.NTSB ERA11FA102Accident · 1 fatalField investigationFinal reportCessna 310F · Orange, MAThe pilot did not maintain separation from trees during landing. Contributing to the accident was the pilot’s inadequate preflight planning and lack of recent night flight experience.NTSB WPR11TA083Accident · No injuriesFinal reportQuest Kodiak 100 · Reedsport, ORThe pilot's failure to maintain clearance from power lines during a low-level aerial observation flight. Contributing to the accident was pilot's failure to review a route hazards map prior to initiating the flight.NTSB WPR11CA097Accident · No injuriesData collectionFinal reportCessna 180 · Flagstaff, AZThe pilot's failure to maintain directional control during landing that resulted in a ground loop.NTSB OPS11IA273Incident · No injuriesIncident investigationFinal reportEmbraer ERJ190 · Denver, COThe driver of the operation vehicle's misidentification of the runway for an adjacent taxiway, resulting in a runway incursion with an aircraft in position for takeoff.NTSB ERA11LA105Accident · No injuriesLimited investigationFinal reportCessna 172 · Dublin, NCThe pilot’s improper touchdown speed which resulted in a runway overrun. Contributing to the accident was the undetermined malfunction of the airspeed indicator.NTSB ERA11LA103Accident · No injuriesLimited investigationFinal reportCessna 152 · Wimauma, FLThe mechanic/pilot's failure to detect a visible exhaust gas leak and cracked cylinder head immediately prior to the accident flight, which resulted in a partial loss of engine power during initial climb. Contributing to the accident was an inadequate…NTSB ERA11FA101Accident · 2 fatalField investigationFinal reportCessna 172H · Weyers Cave, VAThe inherent limitations of the see-and-avoid concept, which made it difficult for the helicopter pilot to see the airplane before the collision. Contributing to the accident was the airplane pilot’s non-standard entry to the airport traffic pattern, which,…NTSB CEN11FA133Accident · 2 fatalField investigationFinal reportPiper PA-46-310P · Milaca, MNThe pilot did not recover from an unusual attitude while operating in instrument meteorological conditions following a disconnect of the autopilot system for undetermined reasons. Contributing to the accident were the pilot’s lack of recent flight experience…NTSB CEN11CA140Accident · No injuriesData collectionFinal reportRockwell International 114A · North Lima, OHThe pilot’s failure to maintain directional control during the landing touchdown.NTSB ERA11LA106Accident · No injuriesLimited investigationFinal reportEurocopter MBB-BK · Cherry Point, NCThe pilot's impairment during cruise flight due to a recurring stroke. Contributing to the accident was the Federal Aviation Administration's inadequate oversight of the pilot's known medical condition.NTSB ENG11WA017Incident · No injuriesForeign investigationAirbus A320 · Changchun, China, ChinaOn December 29, 2010, a China Eastern Airlines Airbus A320-214, powered by two CFM56-5B4/P turbofan engines experienced a No. 2 engine (right) engine failure during the initial takeoff roll from Changchum Airport, Changchum, China. During initial take-off run…NTSB DCA11IA015Incident · No injuriesClass 1 · IncidentFinal reportBoeing 757-223 · Jackson Hole, WYa manufacturing defect in a clutch mechanism that prevented the speedbrakes from automatically deploying after touchdown, and the captain’s failure to monitor and extend the speedbrakes manually. Also causal was the failure of the thrust reversers to deploy…NTSB CEN11CA132Accident · No injuriesData collectionFinal reportCessna T210L · Abilene, TXThe pilot’s improper fuel management, which resulted in a loss of engine power due to fuel exhaustion.NTSB CEN11RA149Accident · Serious injuriesForeign investigationMcdonnell Douglas 600 · Jena-Isserstedt, GermanyOn December 28, 2010, at 1420 UTC, a MD-Helicopters MD600N, German registration D-HHWR, lost engine power and subsequently impacted terrain near Jena-Isserstedt, Thuringen, German. The pilot and second pilot on board the helicopter sustained serious injuries.…NTSB CEN11CA136Accident · Minor injuriesData collectionFinal reportAero Commander 500-B · Columbus, OHThe pilot’s improper fuel management which resulted in a loss of engine power due to fuel exhaustion.