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 SEA06CA123Accident · No injuriesData collectionFinal reportSchweizer G-164B · Murtaugh, IDThe pilot's excessive brake application during the landing roll, which resulted in a nose over.NTSB NYC06LA151Accident · No injuriesLimited investigationFinal reportBoeing 767-300 · Dulles, VAThe driver's failure to follow company standard operating procedures. A factor was the driver's diverted attention to an on-time departure.NTSB NYC06CA152Accident · No injuriesData collectionFinal reportCessna 182F · Beverly, MACollapse of the nose landing gear for an undetermined reason.NTSB NYC06CA150Accident · No injuriesData collectionFinal reportEiriavion PIK 20B · Mt. Holly Sprin, PAThe pilot's failure to maintain altitude/clearance from trees along his final approach path.NTSB NYC06CA148Accident · Serious injuriesData collectionFinal reportTaylorcraft DC-65 · Parma, NYAn uncontrolled descent into trees and terrain after takeoff for undetermined reasons.NTSB LAX06LA205Accident · No injuriesLimited investigationFinal reportCessna 177B · Redwood City, CAA collision with water for undetermined reasons.NTSB CHI06CA168Accident · No injuriesData collectionFinal reportSchweizer 269C · Grand Forks, NDThe dual student's failure to maintain rotor speed during the recovery from the intentional autorotation and the flight instructor's delayed remedial action. Contributing factors were the flight crew's intentional autorotation and dual student's misjudged…NTSB CHI06CA155Accident · No injuriesData collectionFinal reportMcFarland Rotorway Exec · Mooresville, INAn in-flight fire for undetermined reasons.NTSB NYC06CA211Accident · No injuriesData collectionFinal reportErcoupe 415-C · Harrisonburg, VAThe pilot's improper engine starting procedure, resulting in an uncontrolled taxi, and collision with trees.NTSB NYC06CA172Accident · No injuriesData collectionFinal reportRotorway 162-F · Brookhaven, NYThe student pilot inadvertently allowing the skids to contact the ground resulting in dynamic rollover.NTSB NYC06CA153Accident · No injuriesData collectionFinal reportPiper PA-22-108 · South Boston, VAThe pilot's failure to maintain directional control, which resulted in a collision with a rising embankment. A factor in the accident was the pilot's lack of recent flight experience.NTSB SEA06LA121Accident · Minor injuriesLimited investigationFinal reportBell 206L · Vernal, UTThe loss of tail rotor effectiveness during an attempted precationary landing after a takeoff over uneven, sloping, brush-covered terrain. Factors include the pilot using the wrong performance chart while completing his preflight performance calculations, the…NTSB NYC06LA147Accident · No injuriesLimited investigationFinal reportCessna 150D · Bloomfield, KYThe pilot's inadequate fuel consumption calculations, which resulted in fuel exhaustion and subsequent loss of engine power.NTSB DFW06CA161Accident · No injuriesData collectionFinal reportLindstrand Balloons 105A · Frisco, TXThe pilot's failure to maintain the proper glidepath while landing. Contributing factors were the prevailing high winds and the downdraft encountered on final approach.NTSB DCA06WA052Accident · No injuriesForeign investigationBoeing B737-300 · East Midlands, United KingdomNTSB DCA06WA051Incident · No injuriesForeign investigationBoeing B737-400 · Catania, ItalyNTSB CHI06LA278Accident · No injuriesLimited investigationFinal reportPiper PA-18A-150 · Lawrenceville, ILThe visual separation from the glider attempted by the tow pilot and traffic advisories from the glider not received by the tow pilot. The airport sign/marker was a contributing factor.NTSB ANC06CA071Accident · No injuriesData collectionFinal reportCessna 185F · Anchorage, AKThe loss of engine power for an undetermined reason, which resulted in an emergency landing and an in-flight collision with trees.NTSB NYC06FA145Accident · 2 fatalField investigationFinal reportRaytheon B36TC · North Garden, VAThe pilot's failure to maintain airspeed while turning onto the final approach, which resulted in an inadvertent stall/spin and subsequent impact with terrain.NTSB NYC06CA146Accident · Serious injuriesData collectionFinal reportTheordore Jankowski Rans S-12 · Caribou, METhe pilot's failure to maintain directional control which resulted in a subsequent impact with trees. A factor in the accident was the unmowed area of vegetation.NTSB ENG06IA020Incident · No injuriesIncident investigationFinal reportRaytheon Corporate Jets Beechjet 400A · Norfolk, VAHigh-altitude ice crystals that had accreted on the compressor vanes and were ingested into the engine high pressure compressor when the pilots retarded the power levers causing compressor surges and the flameouts of both engines. Contributing factors were…NTSB DEN06CA089Accident · No injuriesData collectionFinal reportCessna TU206G · Alamosa, COthe pilot's failure to maintain aircraft control during the landing. Contributing factors include the gusty winds, the crosswind, and the pilot exceeding the maximum demonstrated crosswind component for the airplane.NTSB DEN06CA088Accident · Minor injuriesData collectionFinal reportGrumman-Schweizer G-164A · Cokeville, WYthe pilot's failure to maintain directional control resulting in a ground loop. Contributing factors included the high winds and crosswind.NTSB ATL06LA093Accident · No injuriesLimited investigationFinal reportAyres S2R-G6 · Selma, ALThe loss of engine power during the approach to land due to an uncontained turbine failure, which resulted in an in-flight fire.NTSB NYC06LA144Accident · 1 fatalLimited investigationFinal reportTaylorcraft BC12-D · Mayville, NYThe flight instructor's improper decision to attempt a simulated engine failure at a low altitude and her failure to maintain clearance from trees and wires, while maneuvering. Also causal was the flight instructor's impairment from prescription medication.NTSB CHI06FA154Accident · 2 fatalField investigationFinal reportPiper PA-32R-301T · Parkville, MOThe pilot's improperly planned approach which resulted in the encounter with wake turbulence while the airplane's airspeed exceeded maneuvering speed. This encounter resulted in the subsequent loss of aircraft control and the in-flight separation of the left…NTSB ATL06CA092Accident · No injuriesData collectionFinal reportCessna 150M · Shelby, NCThe student pilot's improper preflight inspection and his failure to refuel the airplane resulting in fuel exhaustion and subsequent loss of engine power.NTSB ANC06LA068Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Palmer, AKThe pilot's selection of unsuitable terrain for landing, which resulted in the airplane nosing over during the landing roll. A factor associated with the accident was the rocky terrain.NTSB WAS06WA013Incident · No injuriesForeign investigationBoeing 737-2m2 · Accra, GhanaNTSB MIA06FA117Accident · 1 fatalField investigationFinal reportBeech 65-A90-1 · Tampa, FLThe poor in-flight planning decision by the captain for his failure to establish the airplane on a stabilized approach for a forced landing, resulting in the airplane landing on a taxiway near the departure end of the runway. Contributing to the accident were…NTSB DFW06LA159Accident · Serious injuriesLimited investigationFinal reportPiper J3C-65 · Stugartt, ARThe pilot's failure to maintain clearance from high brush during takeoff. Contributing factors were the short runway and the high density altitude.NTSB DFW06CA165Accident · No injuriesData collectionFinal reportCessna 210 · Lawton, OKThe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB DEN06CA087Accident · No injuriesData collectionFinal reportPiper PA-28-150 · Antonito, COthe pilot's failure to attain a safe altitude before attempting to cross mountainous terrain. Contributing factors were the downdrafts and the high density altitude conditions.NTSB CHI06CA160Accident · Serious injuriesData collectionFinal reportHead Balloons AX8-88 · Gretna, NEA run-on landing encountered by the pilot of the balloon due to the prevailing winds. The unfavorable winds were a contributing factor.NTSB ATL06CA091Accident · Serious injuriesData collectionFinal reportKearn Breezy · Dover, NCThe pilot's failure to ensure the airplane contained adequate fuel for the flight resulting in a loss of engine power due to fuel exhaustion.NTSB LAX06LA204Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Camarillo, CAa loss of engine power for undetermined reasons. A factor was the soft terrain encountered during the emergency landing.NTSB DEN06CA086Accident · Serious injuriesData collectionFinal reportRolladen-Schneider LS-3 · Buena Vista, COthe pilot's failure to maintain aircraft control resulting in an inadvertent stall/mush. Contributing to the accident was the downdraft.NTSB LAX06CA208Accident · No injuriesData collectionFinal reportCessna 210B · Flagstaff, AZThe pilot's misjudged flare and inadequate recovery from a bounced landing, which resulted in a hard landing and a porpoise.NTSB LAX06CA203Accident · No injuriesData collectionFinal reportAircraft Mfg & Dev. CH2000 · Chandler, AZThe student pilot's failure to maintain directional control and the instructor's delayed remedial actions, which resulted in a collision with terrain during the initial takeoff climb. The instructor's inadequate supervision of the flight was also causal.NTSB DFW06CA160Accident · Serious injuriesData collectionFinal reportPiper PA-28-151 · Brownwood, TXThe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB DFW06CA157Accident · Serious injuriesData collectionFinal reportCaproni Vizzola Cos. Aero. Calif A-21 · San Antonio, TXThe pilot/owner's failure to properly secure the right wing, which resulted in the in-flight separation of the right wing.NTSB DEN06IA083Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas MD-90-30 · Denver, COa brake fire for reasons undetermined. A contributing factor was the inadequate inspection by the maintenance crew.NTSB DEN06CA085Accident · No injuriesData collectionFinal reportBrent W. Brown Murphy Moose · St. Francis, KSthe pilot's failure to open the fuel selector valve, resulting in fuel starvation. Contributing factors were the pilot's failure to use a checklist, his attention being diverted, and the fence.NTSB DEN06CA084Accident · No injuriesData collectionFinal reportMalott Mustang II · Peyton, COthe pilot's failure to maintain control of the airplane. A contributing factor was the wind gust.NTSB SEA06FA116Accident · 3 fatalField investigationFinal reportLciv Lancair IV-P Propjet · Provo, UTThe pilot's failure to maintain altitude/clearance during a VFR approach, which resulted in an in-flight collision with water. Contributing factors were the dark night light conditions and the low clouds.NTSB LAX06WA202Accident · No injuriesForeign investigationPiper PA-44-180 · Pacific Ocean (Pacific Ocean)NTSB DFW06CA166Accident · No injuriesData collectionFinal reportCessna 172A · Durant, OKThe pilot's failure to maintain airspeed resulting in an inadvertent stall/spin.NTSB CHI06CA153Accident · No injuriesData collectionFinal reportCessna R182 · Cooperstown, NDThe pilot's inability to gain sufficient altitude during the aborted landing. Factors associated with the accident were the tailwind, the pilot's selection of the runway used, the wet runway, the roadway, and the corn crop.NTSB CHI06CA151Accident · No injuriesData collectionFinal reportCessna 172N · Athens, OHThe student pilot's inadequate compensation for the wind conditions. Factors associated with the accident were the gusty crosswind, and the ditch.NTSB SEA06FA115Accident · 2 fatalField investigationFinal reportCessna TU206G · Mullan, IDThe pilot's VFR flight into IMC and his subsequent failure to maintain terrain clearance. The pilot's inadequate inflight planning/decision, mountain obscuration, trees and high terrain were factors.