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 NYC90FA075Accident · 2 fatalField investigationFinal reportPiper PA-38-112 · Smithfield, RIImproper in-flight planning/decision by the pilot, which resulted in insufficient altitude to recover from a stall. Factors related to the accident were: the pilot's lack of total experience and excessive gross weight of the airplane.Mar 8, 1990 · N2603G · DestroyedNTSB MIA90FA081Accident · 2 fatalField investigationFinal reportAerospatiale 350D · Miami, FLFatigue failure of an engine turbine blade, which resulted in a loss of power. Rough ocean water in the emergency landing area was a related factor.Mar 8, 1990 · N5778W · DestroyedNTSB FTW90FA079Accident · 2 fatalField investigationFinal reportPiper PA-38-112 · Grand Prairie, TXThe CFI pilot failed to maintain flying speed, and the resultant inadvertent stall. Contributing to the accident was the existing low ceiling.Mar 8, 1990 · N2456P · DestroyedNTSB ATL90FA074Accident · 1 fatalField investigationFinal reportPiper PA-30 · Dayton, TNThe pilot's intentional use of an autopilot with known deficiencies. The pilot knowingly relied on this autopilot which malfunctioned in flight and resulted in his becoming spatially disorientated.Mar 8, 1990 · N7123Y · DestroyedNTSB MIA90LA084Accident · No injuriesLimited investigationFinal reportGrumman American AA-1B · San Juan, PRFailure of the student pilot to maintain directional control of the aircraft while taxiing.Mar 7, 1990 · N1492R · Substantial damageNTSB MIA90LA080Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Clearwater, FLThe pilot's improper flare and improper recovery from a bounced landing, which resulted in a porpoise and loss of aircraft control. Factors related to the accident were: the gusty crosswind, and failure of the pilot to maintain runway alignment.Mar 7, 1990 · N73929 · Substantial damageNTSB MIA90LA079Accident · Minor injuriesLimited investigationFinal reportBeech 76 · Boca Raton, FLImproper remedial action by the pilot. A factor related to the accident was: loss of engine power in the right engine due to an undetermined reason.Mar 7, 1990 · N330AC · Substantial damageNTSB DEN90LA071Accident · No injuriesLimited investigationFinal reportCessna 402B · Alamogordo, NMThe collapse of the right main landing gear as a result of the malfunction of the down lock assembly and failure of the torque tube bracket assembly.Mar 7, 1990 · N3128K · Substantial damageNTSB CHI90LA095Accident · No injuriesLimited investigationFinal reportCessna 152 · Alpena, MIStudent pilot's failure to maintain positive directional control during the takeoff roll. The student pilot's lack of flight experience was a contributing factor in this accident.Mar 7, 1990 · N48690 · Substantial damageNTSB MKC90LA061Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Monette, ARFailure of the engine exhaust valve.Mar 6, 1990 · N8522V · Substantial damageNTSB MIA90LA083Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Rolling Fork, MSThe in-flight separation of the left aileron due to improper maintenance procedures and an inadequate aircraft preflight.Mar 6, 1990 · N23509 · Substantial damageNTSB LAX90LA110Accident · No injuriesLimited investigationFinal reportCessna 208B · Lanai, HIThe pilot's misjudgement of the glide path angle while executing a forced landing at the Lanai airport. Contributing to the accident was the failure of the pilot to properly secure the oil filter cap prior to departure.Mar 6, 1990 · N851FE · Substantial damageNTSB LAX90DVM02Accident · Minor injuriesFinal reportLink VARI-EZE · Hollister, CAThe pilot's misjudgement of altitude and distance to the runway, while on final approach to land. The sunglare was a related factor.Mar 6, 1990 · N144BE · DestroyedNTSB DEN90IA072Incident · No injuriesIncident investigationFinal reportCessna 208A · Wright, WYThe incident was engine failure due to gas producer turbine disc blade failure caused by stress rupture.Mar 6, 1990 · N812FE · No damageNTSB ATL90FA073Accident · No injuriesField investigationFinal reportMBB BO-105S · Benton, ALThe pilot-in-command's inadequate visual lookout. The incorrect wire survey given by the highway patrol personnel was a related factor.Mar 6, 1990 · N105SM · Substantial damageNTSB ANC90LA037Accident · No injuriesLimited investigationFinal reportCessna 180 · Fairbanks, AKImproper installation of the gear axle (use of improper bolts & the wrong number of shims), which resulted in a subsequent failure and loss of control during the landing roll.Mar 6, 1990 · N2428C · Substantial damageNTSB MKC90LA062Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-150 · Lonoke, ARFailure of the pilot to maintain directional control of the aircraft. His lack of experience in the type of aircraft was a related factor.Mar 5, 1990 · N2927P · Substantial damageNTSB MIA90LA082Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Alligator, MSEngine failure due to undetermined reasons resulting in the forced landing.Mar 5, 1990 · N5043X · Substantial damageNTSB MIA90LA078Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Mattson, MSThe no. 6 cylinder which cracked across the top from one spark plug hole to the other, resulting in the loss of engine power.Mar 5, 1990 · N5416 · Substantial damageNTSB ANC90LA036Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Nome, AKThe failure of the left gear axle due to corrosion and fatigue.Mar 5, 1990 · N7853H · Substantial damageNTSB MKC90LA060Accident · No injuriesLimited investigationFinal reportCessna 140 · Brinkley, ARRecovery from bounced landing not performed and porpoise encountered by the pilot in command.Mar 4, 1990 · N90061 · Substantial damageNTSB FTW90LA078Accident · Minor injuriesLimited investigationFinal reportCessna T50-A17 · Brackettville, TXAn engine failure caused by a malfunctioning carburetor and the pilot's misjudging his obstacle clearance which resulted in a wire strike while maneuvering to land. Factors in the accident were the uncommanded deployment of carburetor heat on both engines, an…Mar 4, 1990 · N578EK · Substantial damageNTSB FTW90LA076Accident · Minor injuriesLimited investigationFinal reportBeech 76 · Mesquite, TXThe flight instructor's (cfi's) poor planning/decision, and his inadequate supervison of flight.Mar 4, 1990 · N5433M · Substantial damageNTSB FTW90FA077Accident · 2 fatalField investigationFinal reportPiper PA-24-180 · Fabens, TXThe pilot's failure to maintain adequate airspeed during a takeoff with less than full power resulting in a stall. Contributing factors were the pilot's failure to lean the mixture to compensate for the high density altitude, and the gross improper,…Mar 4, 1990 · N5354P · DestroyedNTSB DEN90LA070Accident · 1 fatalLimited investigationFinal reportChampion 7EC · Pine Ridge, SDThe failure of the pilot to maintain an adequate airspeed, after diverting his attention, which resulted in an inadvertent stall.Mar 4, 1990 · N4301C · DestroyedNTSB CHI90LA093Accident · No injuriesLimited investigationFinal reportCessna 150H · Grygla, MNThe pilot's inadequate preflight preparation/planning, and subsequent fuel exhaustion due to an inadequate supply of fuel. The light condition at dusk, icy terrain (road) and tree were related factors.Mar 4, 1990 · N22923 · Substantial damageNTSB ATL90LA069Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Rockingham, NCPilot's failure to maintain directional control while attempting a landing.Mar 4, 1990 · N57392 · Substantial damageNTSB ATL90FA071Accident · Serious injuriesField investigationFinal reportPiper PA-28-151 · Creola, ALThe pilot's failure to assure that proper maintenance and inspection of the aircraft were completed before flight.Mar 4, 1990 · N991DB · Substantial damageNTSB NYC90LA074Accident · No injuriesLimited investigationFinal reportCessna 177B · Oxford, MAAn off airport landing in unsuitable terrain following a power loss due to a delaminated ceet duct between the air intake screen and carburetor air box.Mar 3, 1990 · N34873 · Substantial damageNTSB MKC90LA059Accident · No injuriesLimited investigationFinal reportMaule M-6-235 · El Dorado, ARFailure of the pilot to maintain directional control, which resulted in an inadvertent ground swerve. A factor related to the accident was: the crosswind.Mar 3, 1990 · N644SL · Substantial damageNTSB MIA90LA077Accident · Minor injuriesLimited investigationFinal reportBell 47G · Miami, FLInadequate preflight by the pilot, which resulted in fuel exhaustion due to an inadequate supply of fuel. The location of trees was a related factor in that the pilot was unable to maintain rotor RPM while attempting to reach a suitable landing area during…Mar 3, 1990 · N4837 · Substantial damageNTSB LAX90LA109Accident · 1 fatalLimited investigationFinal reportCameron O-105 · Phoenix, AZImproper modification of the balloon's fuel/heater system by the owner/operator and failure of the fuel line connection, which resulted in a fuel system leak and gondola (basket) fire.Mar 3, 1990 · N364CB · DestroyedNTSB DEN90LA069Accident · No injuriesLimited investigationFinal reportErco 415C · Tierra Amarilla, NMInduction icing induced power loss. Factors include continuation of flight into IMC conditions, and unsuitable mountainous terrain for a forced landing.Mar 3, 1990 · N99378 · Substantial damageNTSB CHI90LA094Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Wonder Lake, ILThe pilot's inadequate compensation for wind conditions, and his faiiure to maintain proper altitude on final approach to land. Factors related to the accident were: the trees & snowbank.Mar 3, 1990 · N55030 · Substantial damageNTSB CHI90LA092Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Brainerd, MNThe failure of the pilot to maintain proper alignment with the runway.Mar 3, 1990 · N3967K · Substantial damageNTSB ATL90LA072Accident · No injuriesLimited investigationFinal reportCessna 172G · Wanchese, NCThe pilot's premature, discontinued use of carburetor heat.Mar 3, 1990 · N3663L · Substantial damageNTSB ATL90LA068Accident · Minor injuriesLimited investigationFinal reportCessna 177A · Canon, GAImproper use of carburetor heat by the pilot, which resulted in carburetor ice. Factors related to the accident were: carburetor icing conditions, and soft terrain.Mar 3, 1990 · N30367 · Substantial damageNTSB SEA90LA049Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Valmy, NVThe pilots poor inflight planning and decision to land on an abandoned highway in strong gusty crosswind conditions, his improper remedial action of turning downwind at a low altitude after aborting the landing and his failure to maintain airspeed. Factors in…Mar 2, 1990 · N60301 · Substantial damageNTSB SEA90FA074Accident · 2 fatalField investigationFinal reportPiper PA28R-200 · Prairie City, ORUncontrolled spiralling descent that the pilot did not adequately recover from. The pilots lack of total experience in this type of operation and the dark night condition are a factor.Mar 2, 1990 · N2947R · DestroyedNTSB MIA90LA076Accident · No injuriesLimited investigationFinal reportHughes 300C · Vero Beach, FLThe failure of the pilot in command/instructor pilot to maintain adequate rotor RPM after landing from a touchdown autorotation. A factor related to the accident was the gusty wind condition.Mar 2, 1990 · N58275 · Substantial damageNTSB MIA90LA075Accident · Minor injuriesLimited investigationFinal reportZimmerman Varieze · Brooksville, FLLoss of engine power for undetermined reasons during the initial climb shortly after takeoff.Mar 2, 1990 · N16CS · Substantial damageNTSB SEA90LA048Accident · Minor injuriesLimited investigationFinal reportBell BH-47G3B2 · Des Moines, WAPartial loss of engine power, cause undetermined. The aircraft was not recovered and examination of the engine was not possible.Mar 1, 1990 · N4073G · DestroyedNTSB MKC90LA058Accident · No injuriesLimited investigationFinal reportCessna 195 · Garden City, KSDirectional control not maintained by the pilot in command.Mar 1, 1990 · N4332V · Substantial damageNTSB MKC90FA057Accident · 1 fatalField investigationFinal reportBeech B36TC · Inver Grove Hgt, MNPremature lift-off by the pilot, while taking off with a heavy gross weight in unfavorable winds, and the pilot's failure to attain/maintain adequate airspeed, which resulted in an inadvertent stall/mush.Mar 1, 1990 · N3077G · Substantial damageNTSB BFO90LA031Accident · No injuriesLimited investigationFinal reportCessna 152 · Grafton, WVThe pilot's improper use of carburetor heat, when operating at reduced power in conditions which were conducive to carburetor ice.Mar 1, 1990 · N65538 · Substantial damageNTSB LAX90LA107Accident · No injuriesLimited investigationFinal reportBeech B-19 · Chiriaco Summit, CAA engine compartment fire of undetermined origin dduring engine start.Feb 28, 1990 · N24015 · DestroyedNTSB FTW90LA075Accident · Minor injuriesLimited investigationFinal reportCessna 150J · Tomball, TXThe pilot in command's inaccurate fuel consumption calculations, which resulted in loss of engine power due to fuel exhaustion. Factors in this accident were: the dark night, and the soft/wet terrain.Feb 28, 1990 · N51402 · Substantial damageNTSB DEN90FA068Accident · 1 fatalField investigationFinal reportCessna 208A · Denver, COThe accumulation of structural ice and subsequent stalling of the aircraft. The icing condition was a related factor.Feb 28, 1990 · N820FE · DestroyedNTSB CHI90LA091Accident · No injuriesLimited investigationFinal reportCessna 152 · New Lenox, ILPilot's inability to maintain directional control of the aircraft during the touchdown and landing roll phases of flight, due to deposits of slush frozen on the left landing gear brake.Feb 28, 1990 · N67950 · Substantial damageNTSB SEA90LA046Accident · No injuriesLimited investigationFinal reportCessna 182K · Sheridan, ORThe loss of engine power due to the inadequate preflight inspection of the aircraft by the pilot in command.Feb 27, 1990 · N2813R · Substantial damage