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 CHI92FA119Accident · 1 fatalField investigationFinal reportCessna 172H · Browntown, WISpatial disorientation and the pilot's failure to maintain control of the airplane. Factors associated with this accident were the snow conditions, an inadequate weather evaluation by both the student and instructor, over confidence in personal ability,…Apr 1, 1992 · N3884R · DestroyedNTSB ANC92LA056Accident · 2 fatalLimited investigationFinal reportCessna 150 · Kalskag, AKThe pilot's failure to maintain control of the airplane as a result of his physical impairment due to alcohol. A factor was the dark night.Apr 1, 1992 · N11140 · Substantial damageNTSB NYC92LA071Accident · No injuriesLimited investigationFinal reportCessna 140 · Palmer, MAThe improper use of carburetor heat which resulted in a power loss due to carburetor ice over unsuitable terrain. Factors related to the accident were the carburetor icing conditions and the failure of the pilot to be aware of the temperature/dewpoint spread.Mar 31, 1992 · N3047N · Substantial damageNTSB LAX92LA157Accident · No injuriesLimited investigationFinal reportCessna 172 · Prescott, AZThe other airplane's flight instructor's poor supervision of the flight; the other airplane's flight instructor's and dual student's misidentification of the airplane the student pilot was following and the other airplane's flight instructor's and dual…Mar 31, 1992 · N250ER · 2 aircraft · Substantial damageNTSB FTW92LA109Accident · No injuriesLimited investigationFinal reportCessna T188C · Cordel, OKThe animals in the landing area. A factor was the loss of engine power for undetermined reasons.Mar 31, 1992 · N2695J · Substantial damageNTSB DEN92FA045Accident · 1 fatalField investigationFinal reportCessna T210N · Larkspur, COThe pilot's failure to flare the airplane due to his reduced forward visibility. Factors were: the pilot's improper fuel consumption calculations, his failure to proceed to an alternate airport, fuel exhaustion, and weather conditions including snow, fog, and…Mar 31, 1992 · N212CS · DestroyedNTSB FTW92LA101Accident · No injuriesLimited investigationFinal reportWeatherly 201B · Weatherford, OKFuel starvation due to a mechanical failure of the fuel selector. A factor was the lack of suitable terrain.Mar 30, 1992 · N1268W · Substantial damageNTSB FTW92FA099Accident · 1 fatalField investigationFinal reportRockwell 690A · Taos, NMThe pilot in command's failure to maintain the climb after departing the runway environment. Factors were the weather conditions and the dark night.Mar 30, 1992 · N111FL · DestroyedNTSB SEA92LA064Accident · No injuriesLimited investigationFinal reportCessna 152 · Friday Harbor, WAThe pilot's improper recovery from a bounced landing. A factor was the poorly planned approach.Mar 29, 1992 · N25944 · Substantial damageNTSB LAX92FA156Accident · 3 fatalField investigationFinal reportBeech B95 · Devore, CAThe pilot's failure to maintain an adequate altitude while flying over mountainous terrain. Factors related to the accident were: the low clouds, dark night, and mountainous terrain.Mar 29, 1992 · N9652R · DestroyedNTSB DEN92DTE01Accident · 2 fatalFinal reportVans RV-4 · Bennett, COLoss of control by the pilot in command. A factor was: aircraft weight and balance limits exceeded.Mar 29, 1992 · N14BA · DestroyedNTSB ATL92LA072Accident · No injuriesLimited investigationFinal reportCessna U206G · Lafayette, TNThe pilot's inadequate preflight inspections which resulted in oil starvation and eventual failure of the engine. A factor was the rough terrain where the airplane was force landed.Mar 29, 1992 · N9679G · Substantial damageNTSB ANC92LA055Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Kenai, AKTerrain clearance was not maintained. Factors to the accident were: snow covered hilly terrain, and diverted attention.Mar 29, 1992 · N82757 · Substantial damageNTSB LAX92LA252Accident · No injuriesLimited investigationFinal reportBeech B-35 · Newhall, CAImproper ruddervator balancing that resulted in ruddervator flutter. Contributing to the accident was insufficient maintenance information to assure that AD compliance and elevator balancing was performed, and an inadequate annual inspection procedure that…Mar 28, 1992 · N8838A · Substantial damageNTSB LAX92LA155Accident · No injuriesLimited investigationFinal reportBeech C-24R · Phoenix, AZThe flight instructor's inadequate supervision of the flight and the private pilot's failure to maintain airspeed. Contributing to this accident was the failure of the main landing gear due to overload.Mar 28, 1992 · N66350 · DestroyedNTSB LAX92FA154Accident · 1 fatalField investigationFinal reportHughes 269C · Hesperia, CAA failure of the student pilot to maintain adequate rotor RPM. Contributing to the accident was a failure of the instructor pilot to adequately supervise the training flight and a delay in correcting a low rotor RPM condition.Mar 28, 1992 · N9597F · DestroyedNTSB CHI92LA118Accident · Minor injuriesLimited investigationFinal reportCessna TR182 · Joliet, ILThe pilot-in-command's failure to follow emergency procedures, and the failure of the electrical system. Factors contributing to the accident were electrical arcing, and the lack of total experience in the type of aircraft by the pilot-in-command.Mar 28, 1992 · N4822R · DestroyedNTSB BFO92LA049Accident · Minor injuriesLimited investigationFinal reportRobinson R-22B · Phillipsburg, OHThe loss of control due to inadequate rotor RPM.Mar 28, 1992 · N133MB · Substantial damageNTSB ATL92LA071Accident · Minor injuriesLimited investigationFinal reportMooney M20D · Cumberland Is., GAThe loss of the spark plug at a critical point in flight which resulted from the inadequate overhaul of the engine by an unknown person; and the inadvertent stall of the airplane when the pilot failed to maintain airspeed. A factor was the high obstructions…Mar 28, 1992 · N1975Y · Substantial damageNTSB ATL92LA070Accident · No injuriesLimited investigationFinal reportBeech C-23 · Dalton, GAThe pilot's inadequate compensation for gusting winds while taxiing for takeoff which resulted in a lost of control. A factor was gusting quartering tail winds.Mar 28, 1992 · N6003Z · Substantial damageNTSB ANC92LA054Accident · No injuriesLimited investigationFinal reportCessna A185F · Fairbanks, AKPoor in flight planning/decision. Factors to the accident were: snow covered terrain, and wrong runway not identified.Mar 28, 1992 · N3332S · Substantial damageNTSB LAX92LA153Accident · 2 fatalLimited investigationFinal reportBeech F33A · Payson, AZThe pilot's poor preflight planning/preparation by intentionally flying into known adverse weather and his poor in-flight decision by not flying to an alternate airport when the airplane began to encounter icing. Contributing to this accident was the icing…Mar 27, 1992 · N8000J · DestroyedNTSB LAX92LA152Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Watsonville, CAA failure of the pilot to conduct an adequate pre-flight inspection of the aircraft to ensure that the fuel supply was free of contaminates. Contributing to this accident was fuel contamination.Mar 27, 1992 · N149HA · Substantial damageNTSB LAX92FA151Accident · 1 fatalField investigationFinal reportPiper PA 28-236 · Lebec, CAThe pilot's delayed inflight decision to reverse course to avoid forecast adverse weather conditions. Contributing to the accident was icing conditions and lightning.Mar 27, 1992 · N4335N · DestroyedNTSB FTW92LA100Accident · Serious injuriesLimited investigationFinal reportBoeing 757-223 · Hayden, COFailure of the ground personnel to follow published procedures/directives. A factor was the inadequate equipment.Mar 27, 1992 · N615AM · No damageNTSB BFO92FA048Accident · 2 fatalField investigationFinal reportMooney M20M · Youngs Bottom, WVThe pilot's inadequate inflight decision to continue flight in icing condition which resulted in degraded aircraft performance, inadequate airspeed, and aerodynamic stall. A related factor is the pilot's inadequate evaluation of the weather.Mar 27, 1992 · N9136J · DestroyedNTSB ATL92T#A01Accident · No injuriesClass 3Final reportBell 206B III · Jonesboro, GAMar 27, 1992 · N3907N · Substantial damageNTSB ATL92LA069Accident · No injuriesLimited investigationFinal reportPiper PA-34-200 · Tifton, GAThe pilot's improper single engine go-around procedure, in that he failed to raise the flaps and landing gear, and failed to maintain minimum control airspeed. A factor was the unfavorable wind conditions.Mar 27, 1992 · N16209 · Substantial damageNTSB FTW92LA097Accident · No injuriesLimited investigationFinal reportCessna R182RG · Little Rock, ARThe complete loss of engine power due to carburetor icing, and the pilot's delayed application of carburetor heat. Factors were the weather conditions which were highly conducive to carburetor icing, and the unsuitable terrain at the pilot's disposal to…Mar 26, 1992 · N5529S · Substantial damageNTSB FTW92FA098Accident · 1 fatalField investigationFinal reportCessna 172M · Oklahoma City, OKInadvertent stall during aborted landing. Factors were the tailwind, the pilot's selection of the wrong runway for existing wind conditions and his long landing.Mar 26, 1992 · N20059 · DestroyedNTSB ANC92T#A04Accident · No injuriesClass 3Final reportPiper PA-18 · Yakutat, AKMar 26, 1992 · N7058 · Substantial damageNTSB ANC92LA053Accident · No injuriesLimited investigationFinal reportCessna 172N · Anchorage, AKDirectional control was not maintained. A factor to the accident was: inadequate recovery from a bounced landing.Mar 26, 1992 · N733PU · Substantial damageNTSB DEN92LA044Accident · Minor injuriesLimited investigationFinal reportCessna 180 · Erie, COA loss of directional control when the pilot failed to adequately compensate for crosswind conditions during landing roll. A factor was: a 27 knot crosswind gust.Mar 24, 1992 · N3328D · Substantial damageNTSB BFO92LA047Accident · No injuriesLimited investigationFinal reportBell 47G-2 · Pikeville, KYDelamination and subsequent failure of a main rotor blade.Mar 24, 1992 · N2831B · DestroyedNTSB ANC92LA052Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-301 · Sleetmute, AKThe airplane stalled when the pilot failed to maintain flying speed.Mar 24, 1992 · N84547 · Substantial damageNTSB LAX92FA149Accident · Serious injuriesField investigationFinal reportAyres S2R-T34 · Bakersfield, CAA catastrophic wing spar failure precipitated by hidden corrosion and the restricted view of the area of corrosion by the airplane's wing structure.Mar 23, 1992 · N59SK · DestroyedNTSB DCA92MA025Accident · 27 fatalClass 1 · MajorFinal reportFokker 28-4000 · Flushing, NYThe failure of the airline industry and the federal aviation administration to provide flightcrews with procedures, requirements, and criteria compatible with departure delays in conditions conducive to airframe icing and the decision by the flightcrew to…Mar 23, 1992 · N485US · DestroyedNTSB CHI92LA115Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-161 · Lafayette, INThe student pilot's failure to maintain directional control and his delaying the aborted landing.Mar 23, 1992 · N2959R · Substantial damageNTSB CHI92DEP02Accident · No injuriesFinal reportRutan Varieze · Kenosha, WICollapse of the nose landing gear.Mar 23, 1992 · N39L · Substantial damageNTSB CHI92DCA01Accident · No injuriesFinal reportGrumman G-164 · Malden, MOThe pilot could not maintain directional control after one of the main landing gear brakes jammed during a landing roll. The operator did not comply with an airworthiness directive issued to prevent a possible braking system malfunction.Mar 23, 1992 · N580Y · Substantial damageNTSB BFO92FLQ01Accident · 1 fatalFinal reportJames D. Riehm Rotorway Exec · Bowling Green, KYThe pilot's failure to maintain adequate rotor RPM which resulted in the inflight loss of control. Contributing to the accident was the pilot's lack of experience and overconfidence in his ability.Mar 23, 1992 · N191JD · Substantial damageNTSB ANC92LA051Accident · Minor injuriesLimited investigationFinal reportAeronca 15AC · Port Alsworth, AKThe pilot inadvertently conducted VFR flight into IMC conditions. Contributing factors were low ceilings, snow, rain, icing conditions, and whiteout conditions.Mar 23, 1992 · N1469H · Substantial damageNTSB MIA92LA101Accident · Serious injuriesLimited investigationFinal reportMaya, Jaime Rans S-12 · Cabo Rojo, PRFailure of the non FAA certificated pilot to maintain airspeed and the inadvertent stall during an attempted precautionary landing following partial loss of engine power due to undetermined reasons.Mar 22, 1992 · UNREG · Substantial damageNTSB LAX92LA148Accident · Minor injuriesLimited investigationFinal reportCessna 150M · San Andreas, CAThe flight instructor's poor inflight planning/decision by performing a 360 degree turn maneuver at a low altitude.Mar 22, 1992 · N2869V · DestroyedNTSB FTW92LA095Accident · No injuriesLimited investigationFinal reportCessna 150F · Baytown, TXThe pilot's improper use of carburetor heat during the approach in carburetor icing conditions and his improper flare during the emergency landing.Mar 22, 1992 · N35RJ · Substantial damageNTSB CHI92LA116Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Hanover, KSThe pilot's failure to abort the takeoff earlier in the takeoff roll, and the inadvertent stall/mush after lift-off. A factor was the soft terrain.Mar 22, 1992 · N135AT · Substantial damageNTSB ATL92LA067Accident · 1 fatalLimited investigationFinal reportCessna 182 · Barnwell, SCThe pilot's failure to maintain a safe altitude above the ground while making a low pass at night.Mar 22, 1992 · N5441B · Minor damageNTSB ANC92LA050Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Palmer, AKInadequate in-flight planning/decision. Factors to the accident were: icy and snow covered runway, and delayed remedial action.Mar 22, 1992 · N5947D · Substantial damageNTSB LAX92LA147Accident · Serious injuriesLimited investigationFinal reportBoeing 757-222 · Phoenix, AZThe ground guide's failure to follow established procedures and his improper visual lookout by failing to remain clear of the nose gear during the push back operation.Mar 21, 1992 · N519UA · No damageNTSB LAX92LA146Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Huron, CAA separation of the control rotor cuff due to fatigue.Mar 21, 1992 · N93478 · Destroyed