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 ERA16LA094Accident · No injuriesClass 3 · LimitedFinal reportRobinson Helicopter R22 · Lindenhurst, NYA rough running engine as a result of an intermittent failure of the left magneto for reasons that could not be determined, which resulted in a subsequent autorotation, impact with a sign, and rollover.NTSB WPR16LA061Accident · No injuriesLimited investigationFinal reportCessna 210 · Lodi, CAThe pilot's failure to attain a proper touchdown point, which led to a runway excursion.NTSB CEN16FA095Accident · 1 fatalField investigationFinal reportCirrus Design SR22T · Xenia, OHThe pilot's failure to maintain adequate airspeed while turning from the base leg to final, which resulted in the wing's critical angle-of-attack being exceeded and a subsequent aerodynamic stall.NTSB WPR16LA057Accident · Minor injuriesLimited investigationFinal reportEnstrom 280 · Phoenix, AZA total loss of engine power for reasons that could not be determined because postaccident examination of the engine did not reveal any anomalies that would have precluded normal operation.NTSB GAA16CA121Accident · No injuriesData collectionFinal reportGlines Kenneth Tailwind W 8 · Big Bear, CAThe pilot's inadvertent landing off the left side of the snow-covered runway, resulting in a ground loop and nose over.NTSB ENG16RA024Incident · No injuriesForeign investigationAirbus A320 · Suvarnabhumi Airport, ThailandThe Aircraft Accident Investigation Committee of Thailand has notified the NTSB of an incident involving an A320-232 that occurred January 25, 2016. The NTSB has appointed a U.S. Accredited Representative to assist in the investigation under the provisions of…NTSB WPR16WA191Accident · No injuriesForeign investigationVans RV8 · Chiang Mai, ThailandOn January 24, 2016, about 1030 local time, a Van RV-8, HS-GMC, initiated a forced landing near Chiang Mai, Thailand after experiencing a total loss of engine power during cruise flight. The owner/pilot, and one passenger, were not injured; the airplane…NTSB GAA16CA112Accident · No injuriesData collectionFinal reportPiper PA 18A 150 · Auburn, WAThe failure of the pilot receiving instruction to maintain directional control during the landing roll, resulting in a ground-loop.NTSB DCA16CA070Accident · No injuriesData collectionFinal reportMcdonnell Douglas MD 88 · Newark, NJthe ground crew's misjudgment of the distance between the B767 wingtip and the MD-88 tail. Contributing to the accident was the slushy condition of the ramp which limited the maneuvering space available.NTSB GAA16CA113Accident · No injuriesData collectionFinal reportCessna TR182 · Prescott, AZThe pilot's failure to extend the landing gear prior to landing, which resulted in substantial damage to the fuselage during landing.NTSB WPR16LA056Accident · Minor injuriesLimited investigationFinal reportRobinson Helicopter R22 · Las Vegas, NVThe loss of helicopter control as a result of the loss of tail rotor effectiveness.NTSB CEN16WA165Accident · Serious injuriesForeign investigationDiamond DA42 · Vasteras, SwedenOn January 22, 2016, at 1807 universal coordinate time, a Diamond DA42, Swedish registration SE-LVR, operated by Airways Flygutbildning, collided with the terrain in Vasteras, Sweden, following a loss of control. The flight instructor, the pilot receiving…NTSB CEN16WA099Accident · No injuriesForeign investigationEnstrom 280 · Buttwil, SwitzerlandOn January 22, 2016, about 0845 hours universal coordinated time, an Enstrom model 280C helicopter, Swiss registration HB-XLS, sustained damage to the tail rotor control system before liftoff from the Buttwil Airfield (LSZU), Buttwil, Switzerland. The pilot…NTSB CEN16LA102Accident · Minor injuriesLimited investigationFinal reportPiper PA31 · Denton, TXThe total loss of engine power due to fuel exhaustion for reasons that could not be determined because postaccident examination of the airframe and engine did not reveal any anomalies that would have precluded normal operation.NTSB ERA16WA095Accident · 6 fatalForeign investigationAir Tractor AT401 · Londrina, BrazilOn January 20, 2016, about 1910 universal coordinated time, an Air Tractor AT401B, Brazilian registration PT-WFX, was destroyed by collision with a motor vehicle and terrain in Londrina Municipality, State of Parana, Brazil. The Brazilian certificated pilot…NTSB CEN16WA113Accident · No injuriesForeign investigationCirrus Design Cirrus SR20 · Swansea, United KingdomOn January 20, 2016, at 1419 coordinated universal time, a Cirrus SR20, G-GCDC, collided with a parked Piper PA-31-112, G-BLWP, while landing at the Swansea Airport (EGFH), Swansea, Wales. The pilot and two passengers were not seriously injured. The Piper…NTSB GAA16CA110Accident · Minor injuriesData collectionFinal reportPiper PA32RT · Melfa, VAThe pilot's inadequate compensation for a gusting crosswind during landing, which resulted in an aerodynamic stall, impact with a structure, and subsequent postimpact fire.NTSB GAA16CA107Accident · Minor injuriesData collectionFinal reportPiper PA 46 · Ottawa, KSThe flight crews encounter with un-forecasted freezing rain resulting in an uncontrolled descent, forced landing, and substantial damage to the airplane's firewall, and forward pressure bulkhead.NTSB GAA16CA106Accident · No injuriesData collectionFinal reportPiper PA 28RT-201 · Terrell, TXThe private pilot's exceedance of the airplane's critical angle-of-attack during a go-around in gusting crosswind conditions, which resulted in an aerodynamic stall and a collision with terrain short of the runway.NTSB CEN16LA093Accident · No injuriesLimited investigationFinal reportSocata TBM700 · Wichita, KSThe pilot’s failure to maintain the minimum-recommended approach airspeed in icing conditions, which resulted in a loss of airplane control.NTSB WPR16FA055Accident · Serious injuriesField investigationFinal reportAirbus EC130 · Hanalei, HIThe fatigue failure of the engine fuel pipe as a result of vibration caused by a worn starter-generator front bearing support, which excited the fuel pipe and caused it to oscillate at a resonant frequency, and a subsequent loss of engine power due to fuel…NTSB WPR16FA054Accident · 2 fatalField investigationFinal reportCessna 525 · Cedar Fort, UTThe pilot's loss of control due to spatial disorientation while operating in instrument meteorological conditions, which resulted in an exceedance of the airplane's design stress limitations, and a subsequent in-flight breakup. Contributing to the accident…NTSB GAA16CA103Accident · No injuriesData collectionFinal reportAviat A-1C · Breckenridge, TXThe pilot's failure to maintain directional control during the landing roll, which resulted in a ground-loop.NTSB ERA16LA092Accident · No injuriesClass 3 · LimitedFinal reportPiper PA 30 · Dublin, GAThe pilot’s inadvertent retraction of the landing gear during the landing roll following a landing approach in gusting wind conditions.NTSB ERA16LA091Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Madison, GAThe pilot’s improper fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.NTSB ERA16CA093Accident · No injuriesData collectionFinal reportCessna 210 · Venice, FLThe pilot's failure to properly configure the landing gear, which resulted in a landing with the landing gear in the retracted position.NTSB ERA16CA102Accident · No injuriesData collectionFinal reportTucker Mitchel C H 13 · Zephyrhills, FLThe pilot's failure to maintain aircraft control while on ground standing with the engine running during high crosswind conditions which resulted in a static rollover and collision with the ground.NTSB CEN16LA090Accident · No injuriesLimited investigationFinal reportBellanca 17-30A · Overbrook, OKThe pilot’s inadequate preflight fuel planning, which resulted in a total loss of engine power due to fuel exhaustion, and his subsequent decision to circle to the north end of the airport due to a light tailwind condition instead of making a downwind landing.NTSB ERA16LA090Accident · No injuriesLimited investigationFinal reportBeech A23 · Kingston, TNThe pilot's inadequate preflight inspection and fuel planning and his improper in-flight fuel management, which resulted in a total loss of engine power due to fuel starvation.NTSB DCA16WA095Incident · No injuriesForeign investigationBoeing 737 · Kiev, UkraineThe National Bureau of Air Accident Investigation (NBAAI) of Ukraine has notified the NTSB of an accident involving a Boeing 737 airplane that occurred on January 16, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the NBAAI's…NTSB CEN16WA088Accident · 4 fatalForeign investigationSocata TB20 · Cuenca, Spain, SpainOn January 16, 2016, about 1532 coordinated universal time, a Socata TB-20 single engine airplane, serial number 747, registry EC-ESK, was destroyed after impacting terrain near Cuenca, Spain, during cruise flight. The pilot and three passengers were fatally…NTSB GAA16CA109Accident · Minor injuriesData collectionFinal reportCessna CE-208 · Hooper Bay, AKThe pilot's failure to identify the runway, resulting in the airplane touching down a few feet to the right of the runway.NTSB GAA16CA108Accident · No injuriesData collectionFinal reportCessna 180 · Sussex, NJThe student pilot's failure to maintain pitch control during the landing, which resulted in abnormal runway contact, a ground loop, and a nose over.NTSB ERA16WA099Incident · No injuriesForeign investigationCessna 550 · Istanbul, TürkiyeOn January 15, 2016, at 1103 Universal Coordinated Time (UTC), a Cessna 550 Citation I, Turkish registration TC-AHE, operated by Panjet, received minor damage during taxi after landing at Istanbul Atatürk Airport, Instanbul, Turkey (LTBA). The flight…NTSB ERA16FA089Accident · 1 fatalField investigationFinal reportCaughran Terry Flightstar II · Wake, VAFailure of the left wing in flight due to compression loading from wing loads combined with preexisting damage.NTSB CEN16WA148Accident · No injuriesForeign investigationCessna 402 · Leicestershire, United KingdomThe Air Accidents Investigation Branch (AAIB) United Kingdom has notified the NTSB of an accident involving a Cessna 402B, Registration G-MAPP, that occurred on January 14, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB…NTSB CEN16FA087Accident · 1 fatalField investigationFinal reportPiper PA 22-108 · Garden City, TXThe pilot's failure to maintain clearance with terrain during a low altitude flight.NTSB CEN16FA086Accident · 1 fatalField investigationFinal reportBeech C35 · Meeker, COThe non-instrument-rated pilot's decision to fly the airplane in instrument meteorological conditions at high altitude for greater than 30 minutes without the use of supplemental oxygen which resulted in hypoxia, and a subsequent loss of control. Contributing…NTSB GAA16LA100Accident · Serious injuriesLimited investigationFinal reportEnstrom F-28 · Ritter Butte, ORThe pilot’s improper fuel management, which resulted in a total loss of engine power due to fuel exhaustion and subsequent impact with terrain.NTSB GAA16CA105Accident · No injuriesData collectionFinal reportEngineering & Research Ercoupe 415 · Chappell, NEThe pilot's inability to correct for a crosswind during the takeoff roll due to the interlinked flight control design, which resulted in a runway excursion, and a collision with terrain.NTSB DCA16WA083Incident · No injuriesForeign investigationBoeing 777 · Lisbon, PortugalThe government of Portugal has notified the NTSB of an incident involving a Boeing 777 airplane that occurred on January 13, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the government of Portugal's investigation under the…NTSB CEN16FA083Accident · 1 fatalField investigationFinal reportCessna 172N · Gilmer, TXThe pilot's inadequate preflight planning and inspection, which resulted in a total loss of engine power due to fuel exhaustion. Contributing to the accident was the pilot's failure to maintain an appropriate traffic pattern altitude and distance from the…NTSB GAA16CA104Accident · No injuriesData collectionFinal reportCessna 172 · Dothan, ALThe pilot-rated student's hard landing, which resulted in fuselage damage.NTSB CEN16IA091Incident · No injuriesIncident investigationFinal reportMitsubishi MU 300 · Little Rock, ARThe flight crew's inadequate preflight inspection of the airplane, during which they failed to see a fueling mat that had been placed on the inboard trailing edge of the right wing, which the right engine subsequently ingested during the takeoff roll.…NTSB GAA16CA348Accident · No injuriesData collectionFinal reportBeech B200 · Carolina, PRThe pilot's failure to actuate the parking brake prior to leaving his seat, resulting in substantial damage.NTSB GAA16CA101Accident · No injuriesData collectionFinal reportCessna 182 · Baton Rouge, LAAn inadvertent collision with a bird while maneuvering during an aerial observation flight.NTSB ENG16WA008Incident · No injuriesForeign investigationBoeing 767 · Lima, PeruOn January 11, 2016, a Boeing 767-316ER, powered by two General Electric CF6-80C2B6F turbofan engines experienced an inflight uncommnaded shutdown of the right engine. The engine was successfully restarted and the flight continued to its intended destination.…NTSB WPR16LA050Accident · 1 fatalLimited investigationFinal reportMoore Onex · Fresno, CAThe pilot/builder's failure to properly align the Force One Main Bearing, which resulted in a blockage of the oil transfer hole and culminated with a total engine power loss. Contributing to the accident was the pilot's failure to arrest the bank and sink…NTSB ERA16LA086Accident · Serious injuriesLimited investigationFinal reportWayland John H Avid Mark IV · Minneola, FLA total loss of engine power for reasons that could not be determined because postaccident examination revealed no anomalies that would have precluded normal operation. Contributing to the accident was the pilot's exceedance of the airplane’s critical angle…NTSB ERA16LA085Accident · No injuriesClass 3 · LimitedFinal reportCirrus SR22 · Concord, NCThe pilot’s inadequate management of the airplane’s automated systems, which resulted in a loss of control during an instrument approach and necessitated his subsequent deployment of the airplane’s parachute system.