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 ERA12CA040Accident · No injuriesData collectionFinal reportEngineering & Research 415-C · Mebane, NCThe pilot's delay in aborting the takeoff.NTSB DCA12WA006Incident · No injuriesForeign investigationBangkok, ThailandOn October 16, 2011, a Qantas Airlines B747-400, Australian registration VH-OJS, experienced abnormal exhaust temperatures and vibrations in the number 3 engine while climbing. The engine was shutdown and the flight returned to Bangkok. There were no…NTSB CEN12FA021Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Guthrie, OKThe pilot’s inadequate fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.NTSB CEN12CA038Accident · No injuriesData collectionFinal reportPipistrel Sinus 912 · Indianapolis, INThe pilot's failure to maintain directional control of the motor-glider while landing in gusty wind conditions.NTSB CEN12CA026Accident · Serious injuriesData collectionFinal reportJantzen Evans VP · Terrell, TXThe pilot’s inadequate preflight planning, in that he did not determine whether the airplane’s climb performance would be sufficient to clear obstacles before initiating take off.NTSB CEN12CA024Accident · No injuriesData collectionFinal reportWaco Classic YMF-F5C · Moriarty, NMThe pilot's failure to maintain control of the airplane during the landing roll.NTSB WPR12LA013Accident · Minor injuriesLimited investigationFinal reportMiller Avid Flyer · Susanville, CAA total loss of engine power during the takeoff climb for undetermined reasons.NTSB OPS12IA041Incident · No injuriesIncident investigationFinal reportCessna 172S · Daytona Beach, FLThe departing pilot's incorrect runway selection and non-compliance with an air traffic control clearance. Contributing to the incident was the air traffic controller's inadequate monitoring of the departing aircraft to ensure that the pilot complied with the…NTSB ERA12WA041Accident · Serious injuriesForeign investigationBell 412 · Santa Rosa, VenezuelaOn October 15, 2011, at 1933 UTC, a Bell 412SP, YV0126, registered to and operated by Electrificacion del Caroni (EDELCA), as a business flight, collided with trees while on approach to Macagua Airport, Santa Rosa, Venezuela. The Venezuelan Government…NTSB ERA12CA037Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Deland, FLThe pilot's inadequate directional control during the landing roll.NTSB ERA12CA029Accident · No injuriesData collectionFinal reportCessna 180H · Houston, MSThe pilot did not maintain directional control during the landing roll.NTSB CEN12LA047Accident · Serious injuriesLimited investigationFinal reportSaber Trike unk · Okmulgee, OKThe in-flight collision with electrical wires for undetermined reasons.NTSB CEN12CA032Accident · No injuriesData collectionFinal reportPiper PA-28-235 · Radnor, OHThe pilot's failure to properly secure the engine controls prior to manually rotating the propeller, which led to an inadvertent engine start and runaway airplane.NTSB CEN12CA029Accident · Minor injuriesData collectionFinal reportHunt Sparrowhawk · Blair, NEThe pilot/builder’s inadequate installation of a nosewheel steering component, which resulted in a shimmy and a loss of directional control during the takeoff roll.NTSB WPR12CA011Accident · Minor injuriesData collectionFinal reportCessna 170B · Ramona, CAThe pilot’s failure to maintain directional control of the airplane during the landing roll.NTSB ERA12CA027Accident · No injuriesData collectionFinal reportIca Brasov IS-29D2 · Benton, TNThe pilot's improper in-flight planning, which resulted in a low-altitude traffic pattern entry and subsequent collision with telephone wires.NTSB ENG12WA002Accident · 28 fatalForeign investigationDe Havilland DHC8 · Madang, Papua New Guinea, Papua New GuineaOn 13 Oct 2011, at about 1715, at about 10,000 feet during the descent for landing, the overspeed warning horn of a PNG Airlines DHC-8-102 aircraft, Papua New Guinea registration P2-MCJ sounded. At 1717, the crew made a MAYDAY call to ATC, indicating that…NTSB DCA12RA003Accident · 9 fatalForeign investigationCessna 208B · Xakanaka, BotswanaOn October 14, 2011, about 1350 local time, A2-AKD, a Cessna 208B chartered flight, crashed shortly after takeoff from an airstrip near Xakanaka, Botswana. Visual meteorological conditions prevailed. Of the 12 persons on board, the pilot and 8 passengers were…NTSB CEN12WA686Accident · 2 fatalForeign investigationPiper PA-28-140 · Petit-Beauregard, SwitzerlandOn October 14, 2011, at 0857 universal coordinated time, a Piper PA-28-140 airplane, G-BBEF, impacted terrain near Petit-Beauregard, Fontaines-sur-Grandson, Switzerland. The pilot and passenger were both fatally injured. The airplane was destroyed. The…NTSB CEN12WA033Accident · 2 fatalForeign investigationDiamond DA20 · Amurrio, SpainOn October 14, 2011, at 1040 universal coordinated time, a Diamond DA20-C1 airplane, EC-KDS, sustained substantial damage when it impacted terrain near Amurrio, Spain. The two crewmembers sustained fatal injuries. The accident investigation is under the…NTSB CEN12CA031Accident · No injuriesData collectionFinal reportHughes 269A · Fort Worth, TXThe inadvertent entry into ground resonance after a hovering autorotation.NTSB CEN12CA027Accident · No injuriesData collectionFinal reportMichael Cans RV-8 · Breaux Bridge, LAThe pilot's failure to maintain control of the airplane after striking an unseen sinkhole during landing.NTSB CEN12CA022Accident · No injuriesData collectionFinal reportCessna 172P · Ozark, MOThe pilot’s inadequate compensation for gusty crosswind conditions while on approach.NTSB WPR12LA009Accident · No injuriesLimited investigationFinal reportSpink Robert M Pietenpol Aircamper · San Rafael, CAA total loss of engine power during the takeoff climb due to fuel starvation, which resulted from the incorrect installation location of the fuel tank supply line screen that allowed debris to partially block the fuel supply line.NTSB WPR12FA010Accident · 1 fatalField investigationFinal reportDG Flugzeugbau DG 1000S · Cle Elum, WAThe pilot’s failure to maintain airspeed and control after takeoff, which resulted in an aerodynamic stall.NTSB WPR12CA007Accident · No injuriesData collectionFinal reportGreat Lakes 2T-1A · San Diego, CAThe pilot's excessive brake application during landing.NTSB ERA12FA051Accident · 1 fatalField investigationFinal reportCessna 150F · Moncks Corner, SCThe debilitating effects of ethylene glycol poisoning, which resulted in the pilot’s inability to maintain control of the airplane.NTSB WPR12CA008Accident · No injuriesData collectionFinal reportCessna 172P · Cornelius, ORThe airplane’s encounter with an unseen hole or obstacle on the grass runway.NTSB ERA12FA023Accident · Minor injuriesField investigationFinal reportSocata TBM 700 · Hollywood, FLThe pilot’s failure to terminate the flight after observing multiple conflicting errors associated with the inaccurate right fuel quantity indication. Contributing to the accident were the total loss of engine power due to fuel starvation from the right tank,…NTSB ERA12CA168Accident · No injuriesData collectionFinal reportMaule MX-7-180C · Zelienople, PAThe pilot did not maintain directional control during landing.NTSB ERA12CA046Accident · No injuriesData collectionFinal reportCessna 182L · Gainesville, FLThe pilot did not maintain a proper descent rate during the approach, which resulted in a hard landing.NTSB DCA12WA002Incident · No injuriesForeign investigationBoeing 767 · Kansai, JapanOn October 12, 2011, at Kansai International Airport, a Boeing 767-300, registered N588HA, operated by Hawaiian Airlines Inc. (HAL450), received ATC instruction to hold short of runway A. The Hawaiian Airlines airplane entered into the runway at about 21:37.…NTSB CEN12CA017Accident · No injuriesData collectionFinal reportLearjet 60 · Lafayette, INThe pilot's decision to taxi the airplane across an unpaved area after the nosewheel inadvertently departed the ramp pavement.NTSB CEN12CA016Accident · No injuriesData collectionFinal reportCessna 182A · Skiatook, OKA total loss of engine power due to fuel exhaustion as a result of the pilot’s improper fuel management.NTSB WPR12CA005Accident · No injuriesData collectionFinal reportCombs Dale B RV-4 · Madera, CAThe third airplane pilot’s failure to maintain visual contact with the second airplane during the formation flight.NTSB CEN12LA014Accident · Serious injuriesLimited investigationFinal reportPeck Zodiac 601XL · Traverse City, MIA loss of engine power for undetermined reasons.NTSB CEN12CA011Accident · No injuriesData collectionFinal reportCirrus Design SR20 · Englewood, COThe student pilot's improper flare, which resulted in a bounced landing from which he was unable to recover.NTSB WPR12CA006Accident · Minor injuriesData collectionFinal reportLudwig Larry E Bushman · Diamond, WAThe pilot's inadequate recovery from a bounced landing and subsequent failure to maintain aircraft control.NTSB ERA12CA024Accident · No injuriesData collectionFinal reportCessna 182A · Warrenton, VAThe pilot did not ensure that the forward door latch was secured prior to initiating the descent.NTSB ERA12CA020Accident · No injuriesData collectionFinal reportCessna 177B · Honesdale, PAThe pilot’s excessive airspeed during final approach and his delayed decision to abort the landing, resulting in the in-flight collision with trees during the go-around.NTSB ENG12RA028Incident · No injuriesForeign investigationBoeing 737 · Antalya, TürkiyeOn October 10, 2011, a Sky Airlines B737-400 (TC-SKF), S/N 26291 flight ZY 8756 from BADEN (EDSB) to Antalya (LTAI) experience a right landing gear collapse during the landing sequence at Runway 18C. The landing gear tire deflated and A/C collapsed on the…NTSB ENG12IA001Incident · No injuriesIncident investigationFinal reportBoeing 757-251 · Atlanta, GAthe return to service of overhauled airplane engine parts with undetected fatigue cracks, resulting in complete loss of engine power and uncontained engine failure. A contributing factor was the inadequate diffuser and HPT case inspection procedure.NTSB CEN12CA064Accident · No injuriesData collectionFinal reportCessna 210F · Phillipsburg, KSThe pilot’s improper recovery from a bounced landing.NTSB ANC12CA003Accident · No injuriesData collectionFinal reportPiper PA-18 · Skwentna, AKThe pilot's inadequate clearance from a tree during an off-airport landing.NTSB ERA12LA358Accident · No injuriesLimited investigationFinal reportCessna 182C · Efland, NCThe pilot’s loss of directional control during the landing roll, which resulted in a collision with a ditch.NTSB ERA12CA022Accident · No injuriesData collectionFinal reportAeronca 0-58A · Westmoreland, TNThe pilot's inadequate visual lookout and failure to maintain clearance from an obstacle during takeoff.NTSB WPR12CA004Accident · No injuriesData collectionFinal reportCessna T310R · Hilo, HIA total loss of engine power during cruise flight due to fuel exhaustion as a result of the pilot’s improper fuel planning.NTSB ERA12FA017Accident · 1 fatalField investigationFinal reportLuscombe 8A · Dixie, GAMaintenance personnel’s improper installation of the No. 2 cylinder’s connecting rod, which resulted in the disconnection of the rod and a subsequent loss of engine power.NTSB ERA12CA116Accident · No injuriesData collectionFinal reportCessna 188 · Starkville, MSThe pilot did not maintain directional control of the airplane during landing, which resulted in a runway excursion.NTSB CEN12LA023Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Wadsworth, OHThe failure of the brake system during the landing roll, which was caused by a loss of hydraulic fluid as a result of a leak in the piston seal due to brake plates worn beyond their service limits.