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.

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.Mar 11, 1994 · N2965H · Substantial damageNTSB 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.Mar 11, 1994 · N3603R · Substantial damageNTSB SEA94LA080Accident · No injuriesLimited investigationFinal reportUnrein 80-P51D · Scapp00se, ORThe inadvertent unlocking of the tailwheel lock. Factors include the manufacturer's inadequate tailwheel lock.Mar 10, 1994 · N51PL · Substantial damageNTSB 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.Mar 10, 1994 · N4696 · Substantial damageNTSB 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.Mar 10, 1994 · N79136 · Substantial damageNTSB MIA94WA094Accident · Serious injuriesForeign investigationBell 206BIII · Corozal, HondurasMar 10, 1994 · N5239Y · Substantial damageNTSB 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.Mar 10, 1994 · N5368M · Substantial damageNTSB FTW94LA093Accident · Minor injuriesLimited investigationFinal reportBell 206BIII · Lake Charles, LAThe failure of the pilot to adequately perform a preflight. A factor was the soft terrain.Mar 10, 1994 · N57340 · Substantial damageNTSB 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.Mar 10, 1994 · N6811N · Substantial damageNTSB 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.Mar 10, 1994 · N93679 · Substantial damageNTSB 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.Mar 9, 1994 · N6625W · Substantial damageNTSB 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.Mar 8, 1994 · N5790S · Substantial damageNTSB 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.Mar 8, 1994 · N19678 · Substantial damageNTSB 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.Mar 8, 1994 · N1942J · Substantial damageNTSB 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.Mar 8, 1994 · N8319Q · Substantial damageNTSB MIA94LA088Accident · No injuriesLimited investigationFinal reportCessna 150M · Vero Beach, FLThe failure of the student pilot to properly recover from a bounced landing.Mar 8, 1994 · N714MJ · Substantial damageNTSB 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.Mar 8, 1994 · N35112 · DestroyedNTSB FTW94LA092Accident · No injuriesLimited investigationFinal reportRockwell 690C · Hayden, COFailure by the pilot to maintain proper altitude. A factor was dark night conditions.Mar 8, 1994 · N5938K · Substantial damageNTSB MIA94T#A02Accident · No injuriesClass 3Final reportHughes 369E · Scotts Ferry, FLMar 7, 1994 · N25MP · Substantial damageNTSB MIA94LA087Accident · No injuriesLimited investigationFinal reportCessna 152 · Panama City, FLThe improper recovery from a bounced landing by the pilot-in- command.Mar 7, 1994 · N48239 · Substantial damageNTSB 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.Mar 7, 1994 · N2145T · Substantial damageNTSB 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.Mar 7, 1994 · N4310B · Substantial damageNTSB SEA94LA075Accident · No injuriesLimited investigationFinal reportCessna 175A · Stanley, IDThe pilot's failure to maintain the proper descent rate. Factors include downdrafts on final approach.Mar 6, 1994 · N6995E · Substantial damageNTSB SEA94LA074Accident · No injuriesLimited investigationFinal reportBeech 58P · Billings, MTThe pilot's inadvertent retraction of the landing gear while on the runway.Mar 6, 1994 · N717HL · Substantial damageNTSB 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.Mar 6, 1994 · N19679 · Substantial damageNTSB 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.Mar 6, 1994 · N99BR · Substantial damageNTSB 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.Mar 6, 1994 · N7014B · Substantial damageNTSB 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,…Mar 6, 1994 · N3769D · DestroyedNTSB 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…Mar 6, 1994 · N4810U · DestroyedNTSB 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.Mar 5, 1994 · N7139P · Substantial damageNTSB 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.Mar 5, 1994 · N9134A · Substantial damageNTSB 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.Mar 5, 1994 · N20768 · Substantial damageNTSB 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…Mar 5, 1994 · N2142P · Substantial damageNTSB CHI94LA133Accident · No injuriesLimited investigationFinal reportBell 47-62 · Aurora, MOThe dual students inadequate flare and the pilot in command's (flight instructor) delayed remedial action.Mar 5, 1994 · N6711D · Substantial damageNTSB 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.Mar 5, 1994 · N2495L · DestroyedNTSB CHI94DEP02Accident · No injuriesFinal reportCorby Starlet · Watertown, WIThe pilot-in-command's improper use of the elevator and his lack of familiarity with the aircraft.Mar 5, 1994 · N754RG · Substantial damageNTSB 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.Mar 5, 1994 · N43571 · Substantial damageNTSB 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.Mar 5, 1994 · N551TJ · DestroyedNTSB 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.Mar 5, 1994 · N7169L · Substantial damageNTSB 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.Mar 5, 1994 · N738CK · Substantial damageNTSB 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…Mar 5, 1994 · N6469B · Substantial damageNTSB 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.Mar 4, 1994 · N512SK · DestroyedNTSB MIA94LA082Accident · No injuriesLimited investigationFinal reportCessna 190 · Fort Lauderdale, FLLocking of the right main landing gear brake for undetermined reasons.Mar 4, 1994 · N190RC · Substantial damageNTSB 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.Mar 4, 1994 · N6528K · Substantial damageNTSB 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.Mar 4, 1994 · N487ER · Substantial damageNTSB 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.Mar 4, 1994 · N5038M · Substantial damageNTSB 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.Mar 4, 1994 · N2327C · Substantial damageNTSB 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.Mar 4, 1994 · N9192W · DestroyedNTSB 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.Mar 4, 1994 · N22682 · No damageNTSB 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.Mar 4, 1994 · N78DE · Destroyed