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 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.NTSB 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.NTSB MIA95WA009Accident · No injuriesForeign investigationCessna 402B · Exuma Island, BahamasNTSB LAX95T#A01Accident · No injuriesClass 3Final reportCessna 185 · Apple Valley, CANTSB 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.NTSB 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.NTSB 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…NTSB 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.NTSB 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.NTSB 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.NTSB LAX95LA005Accident · Serious injuriesLimited investigationFinal reportHiller UH-12E · Salinas, CAan in-flight engine compartment fire for undetermined reasons.NTSB FTW95LA017Accident · No injuriesLimited investigationFinal reportCessna 172M · Farmington, NMThe pilot's inadequate compensation for wind conditions. Factors were wind shear, crosswinds, and gusts.NTSB BFO95WA004Accident · No injuriesForeign investigationPiper PA28RT-201 · SwitzerlandNTSB 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.NTSB 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.NTSB LAX95LA014Accident · No injuriesLimited investigationFinal reportPiper PA-34-220T · Palo Alto, CAthe pilot's improper bounced landing recovery technique.NTSB NYC95LA006Accident · Minor injuriesLimited investigationFinal reportCessna 140 · Farmington, MELoss of engine power for undetermined reasons.NTSB 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.NTSB MIA95LA005Accident · Minor injuriesLimited investigationFinal reportCessna 172F · Indiantown, FLThe improper landing flare by the pilot resulting in the hard landing.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB CHI95LA010Accident · No injuriesLimited investigationFinal reportGreat Lakes 2T-1A-2 · Mt. Horeb, WIthe pilot's excessive braking while taxiing from landing.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB NYC95LA003Accident · No injuriesLimited investigationFinal reportCessna 172N · Center Harbor, NHThe pilot's inadequate compensation for a crosswind condition.NTSB 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.NTSB FTW95LA012Accident · No injuriesLimited investigationFinal reportCessna 172H · Moro, AREngine compartment fire due to undetermined reasons.NTSB 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.NTSB ATL95LA059Accident · 1 fatalLimited investigationFinal reportHayes LONG-EZ · Collinsville, ALThe pilot continued visual flight into instrument weather conditions, and collided with the ground.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB LAX95LA002Accident · No injuriesLimited investigationFinal reportCessna 172M · Coalinga, CAthe pilot's failure to maintain a proper glide path.NTSB 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.NTSB 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.NTSB SEA95LA003Accident · No injuriesLimited investigationFinal reportCessna 210 · Bend, ORThe failure of the landing gear downlock mechanism to engage due to undetermined reasons.NTSB 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.NTSB FTW95LA015Accident · No injuriesLimited investigationFinal reportCessna 185 · Abbeville, LAThe pilot's failure to compensate for wind conditions. A factor was the crosswind.NTSB 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.NTSB 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.