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 LAX94LA368Accident · 1 fatalLimited investigationFinal reportNorth American SNJ-5 · Reno, NVthat the pilot of the other airplane misjudged the distance between the airplanes. The other airplane pilot's diverted attention to the air race is a factor in this accident.NTSB FTW94LA307Accident · No injuriesLimited investigationFinal reportCessna 140 · Nenana, AKThe pilot's excessive use of the brakes during the aborted takeoff.NTSB FTW94LA303Accident · Serious injuriesLimited investigationFinal reportHarris Dragonfly · Woodville, TXWas fuel starvation. Factors were the jammed float in the fuel sight gage and the lack of suitable terrain.NTSB FTW94FA300Accident · 2 fatalField investigationFinal reportPiper PA-24-260 · Tennesse Colony, TXThe pilot's failure to maintain airspeed and the resultant inadvertent stall/spin. A factor was the loss of engine power for undetermined reasons.NTSB FTW94FA299Accident · 1 fatalField investigationFinal reportBellanca 7ACA · Lakeside, TXThe pilot's failure to maintain minimum required airspeed for flight. A factor was the loss of engine power for undetermined reasons.NTSB CHI94LA344Accident · No injuriesLimited investigationFinal reportPrest Eagle II · Wellsville, KSthe pilot-in-command's inadequate visual lookout.NTSB CHI94LA336Accident · Minor injuriesLimited investigationFinal reportCessna 170 · Lakeville, MNAn inadequate pre-flight inspection by the pilot when he did not insure that all the water was drained from the airplane's fuel tanks. Factors associated with this accident were contaminated fuel and powerlines.NTSB CHI94LA334Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Madison, WIThe pilot-in-command not maintaining a proper glidepath during his final approach to landing. A factor associated with the accident was the lack of recent experience in the type operation performed by the pilot.NTSB CHI94LA332Accident · No injuriesLimited investigationFinal reportCessna 170 · St. Anne, ILEngine failure due to an inadequately reconditioned cylinder.NTSB ANC94LA141Accident · Serious injuriesLimited investigationFinal reportArtic S-1B2 · Wasilla, AKA failure of the pilot to maintain adequate airspeed. A lack of total aeronautical experience was a factor in the accident.NTSB LAX94LA386Accident · 2 fatalLimited investigationFinal reportBell 47G-5 · Pacific Ocean (Pacific Ocean)an in-flight collision with the water for undetermined reasons.NTSB LAX94LA378Accident · No injuriesLimited investigationFinal reportQuickie-Myers Q2 · Van Nuys, CAthe pilot's inadequate landing flare, which resulted in a hard touchdown and buckling of the canard.NTSB LAX94LA366Accident · Serious injuriesLimited investigationFinal reportPiper PA-28R-201 · Fort Bragg, CAthe pilot's failure to adequately anticipate and compensate for the existing crosswind/windshear conditions during the takeoff initial climb.NTSB LAX94FA367Accident · 1 fatalField investigationFinal reportAlon A2 · Orland, CAthe pilot's intentional performance of an aerobatic maneuver which overloaded the outboard portion of the left wing and caused it to fail. Factors which contributed to the accident were the pilot's overconfidence in his ability to perform the maneuver and his…NTSB FTW94LA301Accident · Minor injuriesLimited investigationFinal reportCessna 172K · Russellville, ARThe pilot's inadequate compensation for the crosswind during the takeoff ground roll. A factor was the crosswind.NTSB CHI94LA338Accident · No injuriesLimited investigationFinal reportCessna 172 · Mora, MNwas an improper touchdown by the pilot-in-command. Factor's associated with this accident were the pilot's diverted attention due to his perception of a crosswind condition and the pilot not performing a recovery from a bounced landing.NTSB CHI94LA335Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · W. Lafayette, INThe pilot's improper level-off and recovery from a bounced landing. A factor in the accident was the pilot's lack of training for recovery from bounced landings and/or aborted takeoffs.NTSB CHI94LA333Accident · Serious injuriesLimited investigationFinal reportCessna 210 · Elkhart, INthe pilot's improper use of the fuel selector position which resulted in fuel starvation.NTSB CHI94LA331Accident · No injuriesLimited investigationFinal reportCessna 150 · Winnetka, ILThe loss of engine power due to an undetermined reason. The lack of suitable terrain for the forced landing was a factor.NTSB BFO94FA160Accident · 1 fatalField investigationFinal reportBeech A36 · Barstow, MDThe pilot's failure to maintain clearance from the tower.NTSB ANC94LA142Accident · No injuriesLimited investigationFinal reportde Havilland DHC2 · Whittier, AKThe pilot's inadequate in-flight planning and inadequate compensation for the wind conditions. An initial tail wind and later a crosswind were factors in the accident.NTSB ANC94LA140Accident · Serious injuriesLimited investigationFinal reportPiper PA-18-150 · Wasilla, AKThe pilot's failure to assure that an adequate supply of fuel was available to complete the flight. A factor in the accident was the siphoning of fuel from the fuel cap.NTSB NYC94FA178Accident · 2 fatalField investigationFinal reportPiper PA-28-236 · Vernon, NJThe pilot's failure to maintain aircraft control which resulted a loss of control and inflight collision with the terrain.NTSB LAX94LA365Accident · No injuriesLimited investigationFinal reportCessna 210L · Payson, AZAnimals on the runway.NTSB LAX94LA364Accident · No injuriesLimited investigationFinal reportRockwell 114 · Poway, CAfuel exhaustion due to the pilot's inadequate preflight planning and failure to refuel the aircraft prior to departure.NTSB FTW94LA304Accident · No injuriesLimited investigationFinal reportMooney, Dan Rotorway Exec 90 · Owasso, OKThe flight instructor's inadequate supervision of the student. A factor was the student's failure to maintain adequate rotor RPM.NTSB SEA94LA240Accident · No injuriesLimited investigationFinal reportCessna 180G · Cut Bank, MTInadequate compensation for wind conditions. A factor to the accident was wind gusts.NTSB CHI94FA329Accident · 3 fatalField investigationFinal reportPiper PA-23-250 · Beaver Island, MIThe pilot's failure to maintain control of the airplane. The pilot's buzzing and his impairment of judgment and performance due to alcohol were factors in the accident.NTSB ANC94LA137Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Port Alsworth, AKThe pilot's failure to maintain a positive rate of climb.NTSB MIA94LA211Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Gainesville, FLThe failure of the pilot-in-command to calculate fuel consumption correctly resulting in loss of engine power due to fuel exhaustion.NTSB LAX94WA373Accident · No injuriesForeign investigationPiper PA-28-140 · Prince George, CanadaNTSB FTW94LA298Accident · No injuriesLimited investigationFinal reportCessna 172M · Oil Trough, ARThe pilot's loss of aircraft directional control during the landing roll. A factor was the wet grass landing surface.NTSB CHI94LA328Accident · No injuriesLimited investigationFinal reportMooney M20E · Plymouth, MIthe pilot's improper (maintenance) modification and his initiating an operation with known deficiencies in equipmentNTSB CHI94LA327Accident · Serious injuriesLimited investigationFinal reportPiper PA-60-602P · Port Huron, MIInadequate preflight by the pilot resulting in fuel exhaustion. Inadequate maintenance and inspection was a factor contributing to the accident.NTSB CHI94LA321Accident · No injuriesLimited investigationFinal reportCessna 152 · Decatur, INthe pilot-in-command's failure to maintain a proper altitude and his inadequate visual outlook. A factor was the tower.NTSB SEA94LA239Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Nampa, IDDirectional control was not maintained. A factor to the accident was: inadequate supervision.NTSB FTW94LA297Accident · No injuriesLimited investigationFinal reportWeatherly 620TP · Montrose, ARThe pilot's failure to maintain airspeed and the resultant aerodynamic stall.NTSB CHI94LA325Accident · No injuriesLimited investigationFinal reportCessna 172RG · West Chicago, ILthe pilot-in-command (CFI)'s inadequate supervision. Factors were the abrupt flare by the dual student.NTSB ATL94LA172Accident · No injuriesLimited investigationFinal reportBell 47D1 Wasp · Hazel Green, ALUndetermined.NTSB ATL94FA171Accident · 3 fatalField investigationFinal reportPiper PA-32R-300 · Glenville, NCThe fatigue failure of #4 intake valve. A factor was hilly terrain.NTSB ANC94LA138Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Kodiak, AKA failure of the pilot to adequately compensate for crosswind conditions. A crosswind and rough/uneven terrain were factors in the accident.NTSB ANC94LA136Accident · No injuriesLimited investigationFinal reportCessna 140 · Willow, AKThe pilot's improper starting procedures. Factors in the accident were the unavailability of a parking brake and tiedowns to secure the airplane.NTSB LAX94LA380Accident · No injuriesLimited investigationFinal reportSinger Kitfox IV · Apple Valley, CAfuel exhaustion due to the pilot's failure to refuel prior to departure, and his inaccurate en route fuel consumption calculations.NTSB LAX94LA363Accident · Serious injuriesLimited investigationFinal reportBeech C35 · Borrego Springs, CAThe pilot's inadvertent allowance of a fuel starvation loss of power event and his failure to select a tank containing fuel due to his lack of knowledge about the fuel pump/selector unit operating limitations. Factors in the accident were his limited…NTSB LAX94LA361Accident · 1 fatalLimited investigationFinal reportNorth American P-51D · Reno, NVthe pilot's failure to maintain aircraft control during an attempted forced landing. Factors in the accident were the failure of a propeller blade-feathering oil seal which leaked oil on the windshield, obscuring the pilot's vision.NTSB LAX94FA360Accident · 2 fatalField investigationFinal reportPiper PA-18-135 · Winslow, AZthe pilot's inadvertent stall and uncontrolled descent into the ground from a low altitude while scouting for game.NTSB SEA94FA247Accident · 1 fatalField investigationFinal reportCessna 150J · Roseburg, ORthe pilot's failure to maintain clearance from the terrain.NTSB NYC94LA175Accident · No injuriesLimited investigationFinal reportCessna T210R · Tunkhannock, PAUse of improper procedures during a short field landing which resulted in an overrun and noseover.NTSB NYC94FA176Accident · No injuriesField investigationFinal reportWDL 1B · Farmingdale, NYInadequate design of the airship, which allowed the center ballonet to overfill and to collapse the trunking to the fore and aft ballonets, rendering the airship uncontrollable. Factors related to the accident were: inadequate maintenance by the…NTSB MIA94LA210Accident · Minor injuriesLimited investigationFinal reportBellanca 8GCBC · Panama City Bch, FLThe pilot's failure to see and avoid the banner.