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 FTW95FA019Accident · 1 fatalField investigationFinal reportPiper PA-32-300 · College Station, TXThe pilot's failure to maintain airspeed and the resulting inadvertent stall. Factors were the pilot's inadequate preflight inspection, and his diverted attention to an open cargo door.Oct 15, 1994 · N2964A · DestroyedNTSB ANC95LA003Accident · No injuriesLimited investigationFinal reportCessna A185F · Kotzebue, AKA failure of the pilot to maintain adequate distance from the terrain (snow bank). Flat lighting and low contrast conditions were factors in the accident.Oct 15, 1994 · N20752 · Substantial damageNTSB MIA95WA009Accident · No injuriesForeign investigationCessna 402B · Exuma Island, BahamasOct 14, 1994 · N87178 · Substantial damageNTSB LAX95T#A01Accident · No injuriesClass 3Final reportCessna 185 · Apple Valley, CAOct 14, 1994 · N9497N · Substantial damageNTSB FTW95LA021Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Albuquerque, NMImproper planning/decision by the pilot, while attempting flight into known adverse weather (wind), and his inadequate compensation for wind conditions. The gusty crosswind conditions and turbulence were related factors.Oct 14, 1994 · N3699W · Substantial damageNTSB FTW95IA023Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas MD-11 · Dfw Airport, TXImproper maintenance by unknown persons resulting in a jammed spoiler. A factor was the reversed aileron fitting.Oct 14, 1994 · N1758B · No damageNTSB FTW95FA016Accident · 1 fatalField investigationFinal reportRobinson R22 Beta · Eunice, LAThe pilot's failure to properly use carburetor heat, the formation of carburetor ice, and failure of the pilot to maintain rotor RPM after loss of engine power, which resulted in a loss of control and collision with terrain. A factor related to the accident…Oct 14, 1994 · N80546 · DestroyedNTSB CHI95LA013Accident · No injuriesLimited investigationFinal reportLearjet 23 · Holland, MIThe copilot's misjudgment of the touchdown point, and the pilot in command's inadequate supervision to avoid the accident.Oct 14, 1994 · N20TA · Substantial damageNTSB NYC95LA007Accident · Serious injuriesLimited investigationFinal reportPiper PA-22-108 · Beans Cove, PAThe pilot's failure to maintain adequate obstacle clearance which resulted in an inflight collision with a tree.Oct 13, 1994 · N4878Z · DestroyedNTSB LAX95LA006Accident · Serious injuriesLimited investigationFinal reportPiper PA-24-250 · Lone Pine, CAThe pilot's failure to abort the takeoff, resulting in a premature lift-off. A factor in the accident was the failure of the steering linkage.Oct 13, 1994 · N6976P · Substantial damageNTSB LAX95LA005Accident · Serious injuriesLimited investigationFinal reportHiller UH-12E · Salinas, CAan in-flight engine compartment fire for undetermined reasons.Oct 13, 1994 · N145HA · DestroyedNTSB FTW95LA017Accident · No injuriesLimited investigationFinal reportCessna 172M · Farmington, NMThe pilot's inadequate compensation for wind conditions. Factors were wind shear, crosswinds, and gusts.Oct 13, 1994 · N20384 · Substantial damageNTSB BFO95WA004Accident · No injuriesForeign investigationPiper PA28RT-201 · SwitzerlandOct 13, 1994 · N82507 · Substantial damageNTSB SEA95LA009Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Albany, ORThe failure of the dual student to maintain a proper glidepath and the pilot-in-command's inadequate supervision.Oct 12, 1994 · N4334E · Substantial damageNTSB NYC95LA008Accident · Serious injuriesLimited investigationFinal reportBeech A36 · Amityville, NYThe loss of engine power for undetermined reasons. Also causal was the inspector's improper inflight decision to simulate an emergency beyong the gliding distance to a suitable landing area.Oct 12, 1994 · N601AV · Substantial damageNTSB LAX95LA014Accident · No injuriesLimited investigationFinal reportPiper PA-34-220T · Palo Alto, CAthe pilot's improper bounced landing recovery technique.Oct 12, 1994 · N8154C · Substantial damageNTSB NYC95LA006Accident · Minor injuriesLimited investigationFinal reportCessna 140 · Farmington, MELoss of engine power for undetermined reasons.Oct 11, 1994 · N2450V · Substantial damageNTSB NYC95IA020Incident · No injuriesIncident investigationFinal reportCessna 310R · Rochester, NYInadequate maintenance which resulted in undertorqued bolts, fatigue cracking of the hub, and the separation of the propeller assembly from the engine.Oct 11, 1994 · N5494J · Minor damageNTSB MIA95LA005Accident · Minor injuriesLimited investigationFinal reportCessna 172F · Indiantown, FLThe improper landing flare by the pilot resulting in the hard landing.Oct 11, 1994 · N5415R · Substantial damageNTSB LAX95LA004Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · San Jose, CAthe pilot's mismanagement of the fuel system and his failure to select a tank containing fuel.Oct 11, 1994 · N8413P · Substantial damageNTSB FTW95IA013Incident · No injuriesIncident investigationFinal reportGates Learjet 35A · San Antonio, TXThe uncontained failure of the turbine wheel. A factor was the resultant loss of hydraulic power.Oct 11, 1994 · N46TJ · Minor damageNTSB CHI95LA027Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · Mt. Vernon, MOthe pilot's inadequate visual lookout. A factor associated with the accident is the fence post.Oct 11, 1994 · N5433Z · Substantial damageNTSB SEA95LA008Accident · Minor injuriesLimited investigationFinal reportCessna R172K · St. George, UTInadequate fuel consumption calculations. Factors to the accident were: fuel exhaustion and a parked aircraft in the landing path.Oct 10, 1994 · N7327K · Substantial damageNTSB FTW95LA014Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502 · Lamesa, TXThe loss of directional control on the ground and the pilot's inadvertent ground loop. A factor was the failure by the pilot of the conflicting traffic on the runway to maintain proper traffic separation.Oct 10, 1994 · N133HF · Substantial damageNTSB FTW95LA011Accident · No injuriesLimited investigationFinal reportHughes 269C · Livingston, TXThe improper flare resulting in an undershoot of the intended landing area. A factor was the bird strike.Oct 10, 1994 · N9616F · Substantial damageNTSB CHI95LA010Accident · No injuriesLimited investigationFinal reportGreat Lakes 2T-1A-2 · Mt. Horeb, WIthe pilot's excessive braking while taxiing from landing.Oct 10, 1994 · N933EB · Substantial damageNTSB CHI95LA009Accident · No injuriesLimited investigationFinal reportCessna 152 · Bloomington, ILThe pilot's failure to maintain aircraft control while landing. Factors associated with the accident were the improper landing flare and the pilot's lack of total experience.Oct 10, 1994 · N69187 · Substantial damageNTSB CHI95LA008Accident · Minor injuriesLimited investigationFinal reportCessna T210R · Lakota, NDPartial loss of engine power due to preignition and/or detonation, which resulted in failure of the number 4 cylinder. The unfavorable tailwind for landing was a related factor.Oct 10, 1994 · CGHRG · Substantial damageNTSB BFO95LA003Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Ebensburg, PAThe loss of partial engine power due to the failure of the right magneto's nylon gear on the rotating magnet and the low compression in the number three cylinder.Oct 10, 1994 · N8908J · DestroyedNTSB BFO95LA002Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201T · Syracuse, NYThe failure of the pilot of the AG-5B, N1190L, to see and avoid the PA-28R, N38869. The dark night was a factor.Oct 10, 1994 · N38869 · 2 aircraft · Substantial damageNTSB NYC95LA003Accident · No injuriesLimited investigationFinal reportCessna 172N · Center Harbor, NHThe pilot's inadequate compensation for a crosswind condition.Oct 9, 1994 · N733MV · Substantial damageNTSB NYC95LA002Accident · No injuriesLimited investigationFinal reportCessna 185F · Rochester, MAThe pilot's inadeqaute calculation of fuel and inadeqaute inflight decision which resulted in fuel exhaustion and the loss of engine power.Oct 9, 1994 · N53074 · Substantial damageNTSB FTW95LA012Accident · No injuriesLimited investigationFinal reportCessna 172H · Moro, AREngine compartment fire due to undetermined reasons.Oct 9, 1994 · N8181L · DestroyedNTSB BFO95FA001Accident · 1 fatalField investigationFinal reportCessna 172N · Fancy Gap, VAThe pilot's inadequate inflight planning and his failure to maintain adequate terrain clearance. Other related factors are: fog, rain, VFR flight into IMC, inexperience and mountainous terrain.Oct 9, 1994 · N734NB · DestroyedNTSB ATL95LA059Accident · 1 fatalLimited investigationFinal reportHayes LONG-EZ · Collinsville, ALThe pilot continued visual flight into instrument weather conditions, and collided with the ground.Oct 9, 1994 · N33EZ · Substantial damageNTSB SEA95LA007Accident · Minor injuriesLimited investigationFinal reportBony MB-1 · Madras, ORThe jamming of the rudder during due to undetermined reasons. Contributing to the accident was the pilot-in-command's failure to maintain adequate flying speed while attempting to take remedial action.Oct 8, 1994 · N51MB · DestroyedNTSB SEA95LA006Accident · 2 fatalLimited investigationFinal reportGlines Acro Duster II SA750 · West Jordon, UTThe pilot-in-command's attempt to perform a low altitude flight maneuver, and his failure to maintain adequate airspeed during the maneuver. This led to an unrecoverable aerodynamic stall.Oct 8, 1994 · N31WD · DestroyedNTSB SEA95LA005Accident · Minor injuriesLimited investigationFinal reportLarsen Avid Heavy Hauler · Nampa, IDLoss of engine power for undetermined reasons and the lack of suitable terrain for the forced landing.Oct 8, 1994 · N21LJ · Substantial damageNTSB SEA95LA004Accident · No injuriesLimited investigationFinal reportMonocoupe 110 Special · Langley, WACorrosion and subsequent failure of the elevator hinge attach fitting weld. This allowed the elevator to bend and impinge upon the rudder, subsequently jamming it to the full right position and rendering the aircraft impossible to control.Oct 8, 1994 · N2064 · Substantial damageNTSB NYC95LA004Accident · No injuriesLimited investigationFinal reportCessna 182N · New London, NHthe failure of the number four push rod, which resulted in the complete loss of engine power and forced landing, and the subsequent nose over on soft terrain.Oct 8, 1994 · N8903G · Substantial damageNTSB MIA95FA004Accident · 3 fatalField investigationFinal reportCessna 172N · Ochopee, FLThe pilot's failure to maintain airspeed while maneuvering resulting in an inadvertent stall and an uncontrolled descent until impact in a swamp.Oct 8, 1994 · N4851D · DestroyedNTSB LAX95LA017Accident · No injuriesLimited investigationFinal reportEnstrom F-28C · La Verne, CAan inadvertant entry into a settling with power condition and the flight instructor's inability to correct the situation due to an inadequate altitude above ground.Oct 8, 1994 · N5697D · Substantial damageNTSB LAX95LA002Accident · No injuriesLimited investigationFinal reportCessna 172M · Coalinga, CAthe pilot's failure to maintain a proper glide path.Oct 8, 1994 · N5061R · Substantial damageNTSB CHI95FA011Accident · 2 fatalField investigationFinal reportBeech 58 · Park Rapids, MNthe pilot-in-command's failure to obtain/maintain clearance. Factors were a dark night, low ceiling, high terrain, and weather service not used by the pilot-in-command.Oct 8, 1994 · N258CH · DestroyedNTSB CHI95FA007Accident · 1 fatalField investigationFinal reportAero Commander 690B · Springfield, MOFailure of the pilot to maintain control of the airplane, due to spatial disorientation. A factor related to the accident was: the pilot's lack of recent instrument experience.Oct 8, 1994 · N27MT · DestroyedNTSB SEA95LA003Accident · No injuriesLimited investigationFinal reportCessna 210 · Bend, ORThe failure of the landing gear downlock mechanism to engage due to undetermined reasons.Oct 7, 1994 · N75DA · Substantial damageNTSB NYC95LA005Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Grt Barrington, MAthe pilot's improper flare during landing, which resulted in a hard landing and the subsequent collapsed landing gear. A factor in this accident was the pilot's lack of total recent flying experience and recent experience in make and model.Oct 7, 1994 · N44794 · Substantial damageNTSB FTW95LA015Accident · No injuriesLimited investigationFinal reportCessna 185 · Abbeville, LAThe pilot's failure to compensate for wind conditions. A factor was the crosswind.Oct 6, 1994 · N95DM · Substantial damageNTSB CHI95LA006Accident · Serious injuriesLimited investigationFinal reportJohnson A-4 · Laporte, INthe pilot's inadvertant stall of the airplane while conducting a forced landing. A factor was the engine failure which occurred for an undetermined reason.Oct 6, 1994 · N1730H · DestroyedNTSB MIA95LA003Accident · No injuriesLimited investigationFinal reportPitts S1C · Plant City, FLThe failure of the pilot in command to maintain directional control during landing resulting in the aircraft running off the side of the runway and nosing over in soft terrain.Oct 5, 1994 · N2997G · Substantial damage