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 MIA05CA118Accident · No injuriesData collectionFinal reportHerbert O. Kellerman 173 RG · Venice, FLThe owner/pilot mechanic's inadequate maintenance inspection resulting in a partial loss of engine power due to a loose fuel line.NTSB LAX05LA197Accident · Minor injuriesLimited investigationFinal reportCessna 172L · Santa Ynez, CAthe pilot's failure to maintain adequate airspeed during a go-around in gusty wind conditions, which resulted in a stall and collision with terrain.NTSB LAX05LA196Accident · Minor injuriesLimited investigationFinal reportElan DG 300 · Jean, NVthe glider pilot's failure to release from the towline in a timely manner, and to maintain adequate airspeed. Contributing to the accident was the glider pilot's failure to recognize and correctly recover from the stall in a timely manner, and the inadequate…NTSB DFW05IA150Incident · No injuriesIncident investigationFinal reportCessna 208B · Clarendon, TXThe loss of total engine power due to damage of the compressor stator vanes caused by a foreign object. A contributing factor was an in-flight ingestion of bird(s).NTSB DEN05LA086Accident · Minor injuriesLimited investigationFinal reportBeech S35 · Broomfield, COthe pilot's failure to maintain adequate airspeed which resulted in a stall, and his failure to abort the takeoff. The loss of power for undetermined reasons is a contributing factor.NTSB DEN05CA085Accident · No injuriesData collectionFinal reportRobinson R22 Beta II · Wallsburg, UTthe flight instructor's inadequate in-flight planning and decision making and failure to maintain aircraft control. Contributing factor's include the flight instructor's inadequate supervision of the flight, the student pilot's failure to maintain rotor rpm,…NTSB DCA05MA070Accident · 1 fatalMajor investigationFinal reportEmbraer 170 · Washington, DCThe inexperience of the driver (fleet service agent) in the operation of a belt loader, which resulted in the belt loader being driven under, and colliding with, the airplane.NTSB CHI05LA136Accident · No injuriesLimited investigationFinal reportCessna 182TR · Wheeling, ILThe pilot failed to verify that the landing gear were fully extended and failed to perform the emergency landing gear extention procedures. Factors to the accident included the low hydraulic fluid level, and the weak battery that resulted in a partial…NTSB IAD05LA075Accident · Minor injuriesLimited investigationFinal reportHughes TH-55 · Paintsville, KYthe pilot's inadvertent encounter with ground resonance which resulted in destruction of the helicopter.NTSB ATL05LA094Accident · Serious injuriesLimited investigationFinal reportPiper PA-32R-301T · Tazewell, TNLoss of engine power due to oil starvation; the reason for the oil starvation could not be determined.NTSB ANC05LA079Accident · Minor injuriesLimited investigationFinal reportCessna 206 · Stony River, AKA partially blocked fuel pump, which resulted in a loss of engine power while in cruise flight. A factor associated with the accident was an inoperative electric auxiliary fuel pump.NTSB LAX05LA194Accident · No injuriesLimited investigationFinal reportMaule 7-235 · Truckee, CAthe pilot's inadequate compensation for the wind conditions and failure to maintain directional control during the landing rollout.NTSB LAX05CA195Accident · No injuriesData collectionFinal reportBoeing A75N-1 · Paulden, AZthe pilot's inadequate compensation for wind conditions, and his failure to maintain airspeed which resulted in a stall mush and collision with objects.NTSB IAD05LA072Accident · Serious injuriesLimited investigationFinal reportWeiss Vans RV-8 · Canandaigua, NYPartial blocking of the flight controls by unsecured items in the cockpit, which resulted in a loss of control during takeoff.NTSB DFW05LA151Accident · Minor injuriesLimited investigationFinal reportBeaton RV-6A · Boerne, TXThe hard landing as a result of the pilot’s improper flare and his failure to recover from a bounced landing. A contributing factor was the pilot's diverted attention.NTSB DFW05CA146Accident · No injuriesData collectionFinal reportPiper PA-25-235 · Waller, TXThe pilot's inadequate in-flight planning/decision and his failure to maintain adequate airspeed resulting in fuel exhaustion and a stall.NTSB CHI05LA135Accident · Serious injuriesLimited investigationFinal reportBoeing 757-223 · New Chicago, INThe inadvertent encounter with convectively induced turbulence (CIT) while the aircraft was descending into the terminal area.NTSB ATL05CA093Accident · No injuriesData collectionFinal reportAllegro 2000 · Leasburg, NCThe pilot's inadequate recovery from a bounced landing, resulting in a hard landing, and the subsequent on ground collision with trees.NTSB NYC05CA091Accident · No injuriesData collectionFinal reportAuster Mark 6 · Old Bridge, NJAn overload failure of the right tailwheel steering arm.NTSB IAD05LA073Accident · Serious injuriesLimited investigationFinal reportde Havilland DHC-6 · Rittman, OHThe pilot's improper flare and recovery from a bounced landing, which resulted in a stall and subsequent impact with the ground.NTSB DFW05LA147Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Lake Charles, LAThe failure of the propeller governor which resulted in a forced landing. A contributing factor was the transmission wire.NTSB DFW05FA145Accident · 2 fatalField investigationFinal reportBeech 95-B55 · Jeanerette, LAThe pilot's failure to obtain/maintain sufficient airspeed to maintain control. A contributing factor was the loss of engine power for undetermined reason.NTSB ATL05CA095Accident · Minor injuriesData collectionFinal reportDavid S Robbins Christavia MK 1 · Decherd, TNThe pilot's inadequate preflight planning which resulted in fuel exhaustion and subsequent loss of engine power.NTSB ATL05CA092Accident · Minor injuriesData collectionFinal reportCessna 172 · Crossville, TNThe pilot's continued VFR flight into IMC conditions which resulted in an in-flight collision with trees. A related factor was the clouds.NTSB SEA05IA115Incident · No injuriesIncident investigationFinal reportPiper PA-46-350P · Tacoma, WAThe initiation and propagation of a fatigue crack, over 5,273 hours of cyclic in-flight usage, through approximately 80 percent of the aircraft's right wing spar lower cap.NTSB LAX05GA192Accident · Serious injuriesFinal reportEurocopter AS 350 B2 · Bisbee, AZthe pilot's failure to maintain an adequate forward airspeed, which resulted in an in-flight loss of control due to a loss of tail rotor effectiveness, while operating near the out of ground effect hover capability of the helicopter. Contributing factors to…NTSB LAX05FA193Accident · 1 fatalField investigationFinal reportMooney M20C · Van Nuys, CAThe pilot's decision to attempt flight into instrument meteorological conditions, which resulted in the pilot's loss of aircraft control due to spatial disorientation. Factors in the accident were haze and low ceilings, the night lighting condition, an…NTSB IAD05LA071Accident · No injuriesLimited investigationFinal reportPiper E2 · Hastings, NYFuel starvation due to a blocked fuel line, which resulted in a loss of engine power.NTSB DFW05LA153Accident · No injuriesLimited investigationFinal reportParkwood Enterprises Glasair Super II-S · Los Fresnos, TXA blocked fuel line in the fuel tank, which resulted in a loss of engine power due to fuel starvation.NTSB NYC05CA090Accident · No injuriesData collectionFinal reportCessna 150G · Willimantic, CTThe student pilot's improper recovery from a bounced landing and his failure to maintain directional control while landing.NTSB MIA05WA117Accident · 2 fatalForeign investigationCessna 185 · Neiva, ColombiaNTSB DFW05CA144Accident · Minor injuriesData collectionFinal reportHughes 269A · Sherman, TXThe applicant's failure to maintain directional control of the helicopter during a simulated power failure from a hover and the FAA inspector's delayed remedial action resulted in a dynamic rollover.NTSB DCA05MA071Accident · Serious injuriesMajor investigationFinal reportBombardier CL-600-2B19 · Chicago O'Hare, ILThe opening of the service door when the airplane was pressurized. Contributing to the accident was the captain's failure to ensure that one of the airplane doors was open while a ground-cooling cart was connected, which resulted in pressurizing the airplane…NTSB SEA05LA110Accident · No injuriesLimited investigationFinal reportBeech A-36 · Tacoma, WAThe malfunction of the fuel injection control system, for undetermined reasons, while the aircraft was on base leg for a full-stop landing. Factors include soft terrain in the area where the pilot found it necessary to perform a forced landing.NTSB NYC05LA089Accident · Serious injuriesLimited investigationFinal reportSwearingen SA-226T · Teterboro, NJThe pilot's improper decision to depart with a known deficiency, which resulted in a loss of control during landing at the destination airport. A factor was the fuel control units' improper flight idle fuel flow rate.NTSB MIA05WA115Accident · 5 fatalForeign investigationCessna 206C · Puntarenas, Costa RicaNTSB MIA05LA116Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · Fort Myers, FLInadequate maintenance and repair of the engine top cowling by company maintenance personnel, resulting in failure and separation of the cowling in flight.NTSB IAD05WA097Accident · No injuriesForeign investigationBoeing 737-400 · Jakarta, IndonesiaNTSB DFW05CA148Accident · No injuriesData collectionFinal reportAermacchi Bosbok AM 3-C · Marfa, TXThe pilot's failure to attain adequate airspeed, and his premature liftoff resulting in a loss of directional control.NTSB DFW05CA143Accident · No injuriesData collectionFinal reportLuscombe 8A · Wagoner, OKThe pilots failure to maintain directional control during landing and attempted go-around.NTSB SEA05CA108Accident · No injuriesData collectionFinal reportFisher Mini Max 1300 · Sandy, ORThe pilot's inadequate preflight (his inability to get full elevator down deflection with the flight control stick with shoulder harness and seat belt on) and subsequent loss of aircraft control which resulted in a stall/spin into the trees. Contributing…NTSB MIA05LA119Accident · 1 fatalLimited investigationFinal reportWatson Slip Stream · Wildwood, FLAn in-flight loss of control during takeoff/initial climb for an undetermined reason, which resulted in a stall/spin, and impact with terrainNTSB LAX05CA191Accident · No injuriesData collectionFinal reportCessna 172N · Stockton, CAthe pilot's improper use of the brakes, and his failure to maintain directional control during the landing rollout.NTSB DFW05LA139Accident · Minor injuriesLimited investigationFinal reportBeech A36 · Arcola, TXThe pilot's failure to maintain directional control and airspeed which resulted in an inadvertent stall while attempting a go-around. A contributing factor was the quartering tailwind.NTSB DFW05CA142Accident · No injuriesData collectionFinal reportWestland Wasp · Denison, TXThe partial loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB DEN05IA084Incident · No injuriesIncident investigationFinal reportde Havilland DHC-8-202 · Denver, COThe improper procedures conducted by the ground personnel and the flight crew's failure to coordinate procedures with the ground personnel during push back operation which resulted in the collision between the ground support vehicle and the airplane. A…NTSB CHI05LA129Accident · No injuriesLimited investigationFinal reportCessna 210B · Friendship, WIThe loss of engine power for an undetermined reason. Contributing factors to the accident were the trees and the dark night light condition.NTSB CHI05CA132Accident · No injuriesData collectionFinal reportCessna 182F · Osage Beach, MOThe pilot's improper flare and his inadequate recovery from the bounced landing which resulted in a hard landing. A factor associated with the accident was the improper landing flare.NTSB CHI05CA131Accident · Minor injuriesData collectionFinal reportCessna TU206G · West Bloomfield, MIThe pilot's inadvertent water landing with the amphibious-float wheels extended causing the airplane to nose over.NTSB ANC05LA086Accident · No injuriesLimited investigationFinal reportCessna 180 · Anchorage, AKThe pilot's inadequate compensation for gusting wind conditions during landing, which resulted in a ground-loop, and structural damage to the airplane. Factors associated with the accident were a ground-loop, and wind gusts.