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 LAX08LA127Accident · No injuriesLimited investigationFinal reportCessna 182H · Prescott, AZA loss of engine power from fuel starvation due to the pilot's mismanagement of the fuel system and failure to select a tank containing fuel.NTSB DEN08LA085Accident · Minor injuriesLimited investigationFinal reportNorth American SNJ-5 · Wolcott, COThe failure of the engine driven fuel pump flange due to oil starvation, resulting in the loss of engine power due to fuel starvation. Contributing to the accident was the lack of suitable terrain for a forced landing.NTSB DEN08CA089Accident · No injuriesData collectionFinal reportGrumman-Schweizer G-164C · De Witt, ARThe pilot's improper decision to attempt to close the canopy in flight, and his diverted attention resulting in the airplane impacting the terrain. Contributing to the accident was the excessively worn canopy latch.NTSB DEN08CA084Accident · Minor injuriesData collectionFinal reportPiper PA-25-235 · Mountain Grove, MOthe pilot's failure to maintain clearance with the power line.NTSB CHI08LA124Accident · 1 fatalLimited investigationFinal reportPiper PA-25-235 · New Lisbon, WIThe pilot's failure to maintain adequate altitude during a course reversal at the completion of an agricultural spray run.NTSB CHI08LA123Accident · 1 fatalLimited investigationFinal reportDickenson Bathtub · Broadhead, WIThe pilot's failure to maintain adequate airspeed during approach, which resulted in an aerodynamic stall.NTSB ANC08CA062Accident · No injuriesData collectionFinal reportCessna 185 · Talkeetna, AKThe pilot's failure to maintain directional control during the landing roll. Contributing to the accident was an inadvertent ground-loop.NTSB SEA08CA122Accident · Serious injuriesData collectionFinal reportSchempp-Hirth Nimbus-4M · Ephrata, WAThe pilot's inadequate preflight inspection and his failure to connect the left aileron control rod during assembly.NTSB SEA08CA121Accident · No injuriesData collectionFinal reportExtra Flugzeugbau EA300/L · Great Falls, MTThe pilot's misjudged landing flare. A contributing factor was the glare from the sun.NTSB NYC08WA182Accident · No injuriesClass 5 · ForeignBell 407 · Santiago, ChileOn May 4, 2008, about 1640 Chilean local time, a Bell 407, Chilean registry CC-PHI, was substantially damaged when it impacted a highway light pole while approaching Vitacura Airport (SCLC), Santiago, Chile. The Chilean certificated private pilot and three…NTSB MIA08LA101Accident · No injuriesLimited investigationFinal reportHigher Class Sport Hornet · Appling, GAThe interruption of fuel flow for undetermined reasons, resulting in a loss of engine power during flight.NTSB MIA08LA096Accident · 1 fatalLimited investigationFinal reportGarrett Gerald P Cozy Mark IV · Jekyll Island, GAControlled flight into water for undetermined reasons.NTSB LAX08CA125Accident · Minor injuriesData collectionFinal reportGrumman AA-5A · Atlanta, IDThe pilot's failure to attain and maintain an adequate airspeed during the takeoff to clear trees during the initial climb. Contributing factors were the soft and rough nature of the short runway surface.NTSB CHI08LA125Accident · Serious injuriesLimited investigationFinal reportRans S-12 XL · Pelion, SCA loss of engine power due to the improper actions of the instructor pilot and the low experience level of the instructor pilot in this make and model of aircraft.NTSB CHI08CA120Accident · No injuriesData collectionFinal reportCessna 177 · Bellefontaine, OHThe pilot's failure to maintain directional control during the aborted landing. Contributing to the accident was the fence.NTSB SEA08LA119Accident · Serious injuriesLimited investigationFinal reportCameron Balloons C-100 · Phoenix, AZThe pilot's inadequate weather evaluation during the landing approach. Contributing to the accident were windshear and rocky terrain.NTSB SEA08LA117Accident · No injuriesLimited investigationFinal reportRockwell 690C · Minden, NVThe collapse of both main landing gear for undetermined reasons.NTSB SEA08FA116Accident · 3 fatalField investigationFinal reportCessna 172N · McCall, IDThe failure of the pilot to maintain adequate visual lookout and clearance from another airplane while attempting to land on the same runway. Contributing to the accident was the non-standard pattern entry of the pilot.NTSB SEA08CA126Accident · No injuriesData collectionFinal reportCessna 172M · Dixie, IDThe pilot's failure to maintain adequate clearance from the vegetation during takeoff.NTSB SEA08CA123Accident · Minor injuriesData collectionFinal reportVans RV-7A · Hollister, CAThe in-flight collision with a bird.NTSB NYC08FA174Accident · 3 fatalField investigationFinal reportBeech A35 · Americus, GAThe pilot's failure to maintain control during the initial climb for undetermined reasons.NTSB LAX08CA129Accident · No injuriesData collectionFinal reportCessna A185F · Mexican Hat, UTThe pilot's failure to maintain directional control.NTSB DFW08LA130Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-108 · Opelousas, LALoss of engine power due to starvation of the right fuel tank and the inability to select the left fuel tank. Contributing to airplane damage was the hidden obstruction in the field selected for the forced landing.NTSB DFW08CA127Accident · Minor injuriesData collectionFinal reportThompson Howard Pazmany PL-2 · Wagner, OKLoss of power for undetermined reasons.NTSB ANC08CA048Accident · No injuriesData collectionFinal reportCessna 172 · Anchorge, AKThe pilot's failure to maintain clearance from a road sign while taxiing from landing.NTSB SEA08LA120Accident · 2 fatalLimited investigationFinal reportYakovlev Yak 52 · Vancouver, WAThe pilot's failure to maintain an airspeed sufficient to avoid a stall during a low altitude aerobatic maneuver. Contributing to the accident was the low altitude at which the pilot initiated the maneuver.NTSB SEA08CA118Accident · Minor injuriesData collectionFinal reportStinson 108-3 · Libby, MTThe pilot's inadequate compensation for the crosswind gusts and failure to maintain directional control during the landing rollout.NTSB NYC08WA175Accident · 6 fatalClass 5 · ForeignCessna C-310Q · Ilheua, BrazilOn May 2, 2008, about 2043 universal coordinated time, a Cessna 310Q, Brazilian registration PT-JGX, operated by Aero Star Airlines, disappeared off the coast of Brazil while approaching for landing at Ilheus, Brazil. The airplane was in communication with…NTSB LAX08LA128Accident · No injuriesLimited investigationFinal reportCessna 175A · Rio Linda, CAThe partial loss of engine power due to detonation. Contributing to the accident was trees in the landing area.NTSB LAX08CA126Accident · Serious injuriesData collectionFinal reportRobinson R22 Beta II · Prescott, AZThe instructor's inadequate supervision and delayed remedial action that resulted in ground contact and a rollover.NTSB DFW08CA149Accident · No injuriesData collectionFinal reportBellanca 14-13-3A · San Marcos, TXThe failure of the throttle cable clevis swage. Contributing to the accident was the uneven terrain available for landing.NTSB DCA08RA053Accident · 20 fatalClass 5 · ForeignBeech 1900C · Rumbek, SudanOn May 2, 2008, about 0710 UTC, 5Y-FLE, Beech 1900C, a chartered flight, operated by Flex Air of Nairobi, Kenya, experienced a loss of power in both engines, and crashed near Rumbek, Southern Sudan. The 2 flightcrew and 18 passengers were fatally injured. The…NTSB DFW08IA126Incident · No injuriesIncident investigationFinal report2007 Savage Air Epic LT · Uvalde, TXThe pilot's excessive speed during a turn off the active runway to the taxiway which exceeded the lateral limits of the supporting landing gear structure resulting in the collapse of the left main gear.NTSB NYC08LA172Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-160 · Richmond Hill, GAThe loss of engine power during cruise flight due to fuel exhaustion, and the pilot's inadequate preflight inspection.NTSB DFW08WA123Accident · No injuriesClass 5 · ForeignCessna T310Q · Madrid, SpainOn April 29, 2008, at approximately 0900 Universal Coordinated Time (UTC), a single engine Cessna T310Q, EC-DZV, was destroyed upon impact with terrain while maneuvering in the traffic pattern at Cuatro Vientos airport (LECU), Madrid, Spain. The flight…NTSB DEN08LA082Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-300 · Houston, TXLoss of engine power for reasons undetermined. Contributing to the accident was a lack of suitable terrain for a forced landing.NTSB DCA08WA061Accident · 2 fatalClass 5 · ForeignAgusta/Westland A109S · Paraty, BrazilOn April 30, 2008, at approximately 22:59 UTC, an Agusta Westland A109S helicopter, Brazilian registration PR-IPO, crashed after departure from the Parati/Condomínio Laranjeiras heliport, Rio de Janeiro State, Brazil. There were 2 fatalities. The Brazil…NTSB CHI08CA118Accident · No injuriesData collectionFinal reportLuscombe 8A · Remus, MIThe loss of engine power during approach due to fuel contamination. Contributing to the accident were the unsuitable terrain and a tree.NTSB ANC08LA059Accident · No injuriesLimited investigationFinal reportCessna 560XL · Port Heiden, AKThe flying pilot’s failure to maintain directional control while landing in a crosswind. A factor contributing to the accident was a crosswind.NTSB CHI08CA122Accident · No injuriesData collectionFinal reportEvektor Aerotechnik SportStar Plus · Greenwood, INThe student pilot's failure to maintain control of the airplane during engine run-up.NTSB NYC08WA173Accident · 8 fatalClass 5 · ForeignPiper PA-31-310 · Maiquetia, VenezuelaOn April 28, 2008, about 1425 coordinated universal time (UTC), a Piper PA-31-310, N6463L, was destroyed during impact with residences, shortly after takeoff from Aeropuerto Internacional Del Centro Simon Bolivar (SVMI), Maiquetia, Venezuela. The certificated…NTSB NYC08CA170Accident · Minor injuriesData collectionFinal reportCessna 172F · White Plains, NYThe pilot's failure to maintain the proper glide path during the approach.NTSB DFW08LA122Accident · 1 fatalLimited investigationFinal reportRobinson R44 · Bartlett, TXThe pilot's failure to maintain tail rotor clearance from terrain (embankment) during takeoff.NTSB DFW08LA121Accident · 1 fatalLimited investigationFinal reportTromsness Enterprises Turbine LE · Miami, OKThe pilot's failure to maintain control of the airplane for undetermined reasons. Contributing to the accident included his extensive use of medications and/or his multiple medical conditions and the failure of the FAA to follow up on his reported medication…NTSB DEN08CA086Accident · No injuriesData collectionFinal reportMooney M20E · Erie, COThe pilot failed to maintain directional control of the airplane during the touch and go landing.NTSB DEN08CA083Accident · No injuriesData collectionFinal reportBeech 76 · Cleburne, TXThe failure of the flight instructor and student pilot to extend the landing gear prior to the airplane touching down on the runway.NTSB ANC08CA065Accident · No injuriesData collectionFinal reportde Havilland DHC-3 · Talkeetna, AKThe pilot's selection of an unsuitable landing site, which resulted in an overload failure of the tail ski assembly during the landing roll.NTSB SEA08CA124Accident · No injuriesData collectionFinal reportBell 206B · Murietta, CAThe flight instructor's inadequate supervision and delayed remedial action. A contributing factor to the accident was the dual student's improper flare.NTSB SEA08CA113Accident · No injuriesData collectionFinal reportAir Tractor AT-502 · Waitsburg, WAThe pilot's failure to maintain clearance from the terrain while maneuvering at low altitude. Contributing to the accident was the rising terrain.NTSB MIA08FA094Accident · 2 fatalField investigationFinal reportMooney M20M · Midlothian, VAThe pilot’s improper control inputs resulting from spatial disorientation.