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 CHI94LA103Accident · Minor injuriesLimited investigationFinal reportErcoupe 415-C · Frankfort, MIThe pilot's inadequate preflight and failure to maintain adequate airspeed. A factor was fuel contamination resulting in total loss of engine power on takeoff.NTSB CHI94DEP03Accident · No injuriesFinal reportLancair 360 · Waukesha, WIThe pilot's improper flare during landing. Factors related to the accident were a loss of directional control and rough terrain.NTSB SEA94LA080Accident · No injuriesLimited investigationFinal reportUnrein 80-P51D · Scapp00se, ORThe inadvertent unlocking of the tailwheel lock. Factors include the manufacturer's inadequate tailwheel lock.NTSB SEA94LA079Accident · Minor injuriesLimited investigationFinal reportKelley Stits SA6B · Snohomish, WAThe pilot's failure to maintain adequate airspeed. Factors include a pole off the departure end of the runway.NTSB NYC94LA060Accident · No injuriesLimited investigationFinal reportCessna 172K · Dayton, OHthe pilot's failure to maintain directional control which resulted in a runway overrun. Factors are the pilot's improper recovery from a bounced landing, and his lack of experience.NTSB MIA94WA094Accident · Serious injuriesForeign investigationBell 206BIII · Corozal, HondurasNTSB LAX94LA156Accident · No injuriesLimited investigationFinal reportCessna 152 · Angwin, CAthe failure of the pilot to maintain directional control of the aircraft. A factor in the accident was the pilots lack of total experience.NTSB FTW94LA093Accident · Minor injuriesLimited investigationFinal reportBell 206BIII · Lake Charles, LAThe failure of the pilot to adequately perform a preflight. A factor was the soft terrain.NTSB CHI94LA101Accident · No injuriesLimited investigationFinal reportMooney M20C · Richland Center, WIimproper use of carburetor heat. Factors related to the accident were carburetor icing conditions, and the sign and fence poles.NTSB CHI94LA100Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Eugene, MOimproper use of carbureter heat and a poorly planned precautionary landing approach. Factors related to the accident were carburetor icing conditions, the pilot's lack of total experience, trees and anxiety/apprehension.NTSB CHI94LA102Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Hutchinson, MNthe pilot's failure to maintain directional control. Factors associated with the accident were the crosswind, the pilot's lack of total experience, the concrete block and the dirt back.NTSB SEA94LA078Accident · No injuriesLimited investigationFinal reportSchweizer 2-33A · Heber City, UTThe flight instructor's delayed/inadequate remedial action. Factors include the student pilot's failure to maintain directional control, and unfavorable/variable, gusty winds during the takeoff roll.NTSB SEA94LA077Accident · No injuriesLimited investigationFinal reportCessna 172 · Evanston, WYThe pilot's inadequate compensation for wind conditions. Factors include gusty crosswind, and the pilot's lack of total experience.NTSB SEA94LA076Accident · Minor injuriesLimited investigationFinal reportTucker Kitfox IV · Vancouver, WAAileron flight controls that were jammed by the pilot's seat slipping from its mount. Factors include inadequate seat installation by the manufacturer.NTSB MIA94LA090Accident · No injuriesLimited investigationFinal reportCessna TU206F · Crystal River, FLThe failure of the no 1 piston connecting rod for undetermined causes. The lack of suitable terrain for a forced landing was a factor.NTSB MIA94LA088Accident · No injuriesLimited investigationFinal reportCessna 150M · Vero Beach, FLThe failure of the student pilot to properly recover from a bounced landing.NTSB MIA94FA089Accident · 1 fatalField investigationFinal reportPiper J3C · Pembroke Pines, FLThe pilot's failure to maintain airspeed during a climbing turn after banner pickup and her use of excessive aircraft nose up trim which resulted in an inadvertent stall and spin.NTSB FTW94LA092Accident · No injuriesLimited investigationFinal reportRockwell 690C · Hayden, COFailure by the pilot to maintain proper altitude. A factor was dark night conditions.NTSB MIA94T#A02Accident · No injuriesClass 3Final reportHughes 369E · Scotts Ferry, FLNTSB MIA94LA087Accident · No injuriesLimited investigationFinal reportCessna 152 · Panama City, FLThe improper recovery from a bounced landing by the pilot-in- command.NTSB CHI94LA098Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Madison, WIThe pilot-in-command's poorly planned approach and failure to maintain the proper glidepath. The dark night was a factor.NTSB ANC94LA039Accident · No injuriesLimited investigationFinal reportCessna 170B · Chugiak, AKThe pilot-in-command's improper inflight decision making. Factors contributing to the accident were the mountainous terrain and the downdraft weather conditions.NTSB SEA94LA075Accident · No injuriesLimited investigationFinal reportCessna 175A · Stanley, IDThe pilot's failure to maintain the proper descent rate. Factors include downdrafts on final approach.NTSB SEA94LA074Accident · No injuriesLimited investigationFinal reportBeech 58P · Billings, MTThe pilot's inadvertent retraction of the landing gear while on the runway.NTSB NYC94LA054Accident · Minor injuriesLimited investigationFinal reportCessna 172L · Mt. Sterling, KYInadequate maintenance which resulted in the disconnection of the throttle cable from the carburetor and the subsequent loss of engine power. Factors were the annual inspection not performed, and complacency.NTSB NYC94LA053Accident · Minor injuriesLimited investigationFinal reportPiper PA-23-250 · Parrfield, OHThe pilot's mismanagment of the fuel supply by the improper positioning of the fuel selector valves, which resulted in fuel starvation and the total loss of engine power.NTSB MIA94LA086Accident · 1 fatalLimited investigationFinal reportPiotrowski GIP-1 · Bunnell, FLThe failure of the pilot-in-command to maintain rotor RPM in the gyrocopter on approach. Contributing to the accident was the lack of total experience in gyrocopter flying.NTSB MIA94FA085Accident · 1 fatalField investigationFinal reportDaffron, Harold C. Varieze · Oxford, MSPoor planning/decision by the pilot-in-command for failure to perform high and low speed taxi tests before the flight after repairs and modification of the airplane. Additionally, failure or malfunction of the flight control system for undetermined reasons,…NTSB LAX94LA152Accident · 1 fatalLimited investigationFinal reportCessna 210-5A · Jackpot, NVthe pilot's failure to maintain control of the aircraft's flight path while maneuvering after takeoff in an area of no ground reference lights. Factors in the accident were the pilot's lack of instrument flight experience and the dark nighttime lighting…NTSB NYC94LA055Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · South Bethlehem, NYThe failure of the pilot to maintain proper alignment with the runway and the inadequate snow removal.NTSB MIA94LA084Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · Sanford, FLThe failure of the pilot to maintain airspeed during the forced landing resulting in an inadvertent stall/mush. The total loss of engine power caused by fuel starvation due to inattentiveness by the pilot-in-command (CFI) to the fuel supply was also a cause.NTSB MIA94LA083Accident · Minor injuriesLimited investigationFinal reportHarper, Jack M. Mustang II · Lake City, FLThe failure of the bolts which secure the right main landing gear wheel assembly to the strut assembly.NTSB LAX94LA153Accident · Serious injuriesLimited investigationFinal reportPiper PA-23-180 · Fairfield, AZThe flight instructor's inadvertent movement of the left engine propeller control into the feather position, his decision to by-pass suitable landing sites in an attempt to restart the left engine as the aircraft energy and performance capability…NTSB CHI94LA133Accident · No injuriesLimited investigationFinal reportBell 47-62 · Aurora, MOThe dual students inadequate flare and the pilot in command's (flight instructor) delayed remedial action.NTSB CHI94FA097Accident · 2 fatalField investigationFinal reportPiper PA-38-112 · Inman, KSAn unintentional spin which occurred during the maneuvering phase of a biennial flight review. A factor related to the accident was: the airplane's lateral-directional characteristics at or near the stall speed.NTSB CHI94DEP02Accident · No injuriesFinal reportCorby Starlet · Watertown, WIThe pilot-in-command's improper use of the elevator and his lack of familiarity with the aircraft.NTSB ATL94LA060Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · St. Matthews, SCA loss of engine power for undetermined reasons. A factor was the electric transmission wire located at the forced landing site.NTSB ATL94LA059Accident · No injuriesLimited investigationFinal reportPZL-Bielsko SZD-55-1 · Mcminnville, TNThe failure of the pilot to maintain control of the aircraft during the landing approach.NTSB ATL94LA058Accident · Minor injuriesLimited investigationFinal reportRutan Rutan Long EZ · Kill Devil Hill, NCWas the pilot's failure to adequately sump the fuel system during the preflight inspection.NTSB ATL94LA057Accident · No injuriesLimited investigationFinal reportCessna 182RG · Concord, NCThe pilot's inadequate preflight planning and preparation, in that he did not consider the effects of a wet, grass runway on aircraft performance. Factors were the wet, grass conditions of the runway surface.NTSB ANC94LA038Accident · No injuriesLimited investigationFinal reportCessna 152 · Chugiak, AKThe failure of the student pilot to maintain directional control of the aircraft. Factors contributing to the accident were the frozen main landing gear brake shoe, the uncontrolled airport operations by airport personnel and extreme low temperature…NTSB NYC94FA052Accident · 2 fatalField investigationFinal reportCessna 340 · Westhampton, NYThe pilot's inadequate inflight decision which resulted in ice accretion on the aircraft, degradation of aircraft performance, an aerodynamic stall, loss of control and inflight collision with the ground. Factors were icing conditions.NTSB MIA94LA082Accident · No injuriesLimited investigationFinal reportCessna 190 · Fort Lauderdale, FLLocking of the right main landing gear brake for undetermined reasons.NTSB LAX94LA155Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Chico, CAthe failure of the pilot to obtain/maintain sufficient flying speed during a downwind takeoff and climb, compounded by his reluctance to use full available takeoff power.NTSB LAX94LA154Accident · Serious injuriesLimited investigationFinal reportCessna 172N · Prescott, AZThe student pilot's delayed flare and failure to maintain directional control of the aircraft, and the flight instructor's inadequate supervision of the flight.NTSB LAX94LA151Accident · No injuriesLimited investigationFinal reportBellanca 7ECA · Concord, CAThe pilot's failure to maintain directional control during a touch-and-go landing. A factor in the accident was the pilot's limited expereince in tailwheel aircraft.NTSB LAX94LA150Accident · No injuriesLimited investigationFinal reportRobinson R22B · Long Beach, CAthe student pilot's improper use of the collective and tail rotor controls, and the flight instructor's inadequate supervision of the flight.NTSB LAX94LA148Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-235 · Jackpot, NVthe failure of the pilot to maintain control of the aircraft after his loss of visual contact with outside references. Factors in the accident were the dark night lighting conditions and spatial disorientation.NTSB LAX94LA147Accident · Serious injuriesLimited investigationFinal reportCessna 150H · Sacramento, CAthe child's disregard for prescribed safety procedures which was compounded by the diminishing lighting conditions existing at the time, and her lack of familiarity with an aviation environment.NTSB LAX94FA149Accident · 1 fatalField investigationFinal reportPiper PA-31-350 · Frazier Park, CAthe pilot's failure to select a cruise altitude which would ensure adequate terrain clearance. Contributing factors related to the dark, nighttime condition and to the pilot's lack of attentiveness.