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 NYC04LA141Accident · Minor injuriesLimited investigationFinal reportSchleicher ASK-21 · Warren, VTThe pilot's improper pre-flight and in-flight planning, which resulted in a forced landing after experiencing a loss of thermal lift. A factor was the loss of thermal lift.NTSB LAX04FA241Accident · 1 fatalField investigationFinal reportCessna 337 · Carson City, NVthe pilot's failure to maintain an adequate airspeed while maneuvering during a go-around that led to an inadvertent stall spin.NTSB FTW04CA163Accident · No injuriesData collectionFinal reportCessna 172 · McKinney, TXThe student pilot's improper recovery from a bounced landing.NTSB CHI04CA140Accident · No injuriesData collectionFinal reportCessna 150H · Mount Pleasant, MIThe pilot's improper decision to takeoff downwind from the rough field and his failure to maintain aircraft control. A factor to the accident was the rough/uneven alfalfa field and the tailwind experienced during the takeoff.NTSB ANC04LA065Accident · No injuriesLimited investigationFinal reportPiper PA-18 · McGrath, AKThe pilot's selection of unsuitable terrain for landing, which resulted in the airplane nosing over during the landing roll. A factor contributing to the accident was the presence of soft tundra.NTSB NYC04LA142Accident · No injuriesLimited investigationFinal reportSchweizer 269C · Norfolk, VAThe student pilot's failure to maintain control of the helicopter, which resulted ground resonance. Contributing to the accident was the improperly serviced landing gear dampers.NTSB MIA04WA098Accident · 1 fatalForeign investigationCessna 172 · Trinidad, BoliviaNTSB FTW04LA162Accident · Minor injuriesLimited investigationFinal reportCessna 188B · Rush Springs, OKThe pilot's failure to maintain clearance with a utility pole and power lines while maneuvering during an aerial application.NTSB CHI04LA155Accident · No injuriesLimited investigationFinal reportMitsubishi MU-2B-40 · Waukegan, ILThe pilot's misjudgment of the landing flare which resulted in a hard landing. Contributing factors were the subsequent overload and collapse of the nose landing gear.NTSB NYC04WA222Accident · No injuriesForeign investigationBell 206B · Alice Springs, AustraliaNTSB MIA04LA097Accident · No injuriesLimited investigationFinal reportGulfstream American AA5B · Crystal River, FLThe failure of the number three cylinder exhaust valve which resulted in the partial loss of engine power. The pilot's misjudgment of speed and distance resulted in an overrun of the runway.NTSB DEN04LA091Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Ogden, UTfracture and subsequent total failure of the nose gear strut. A contributing factor was the pilot not being able to control the airplane.NTSB DEN04LA090Accident · No injuriesLimited investigationFinal reportAircraft Mfg & Dev. Aleros CH 2000 · West Jordan, UTthe pilot's improper flare which resulted in a hard landing. Contributing factors were the low altitude and high airspeed, resulting in an unstabilized approach.NTSB ATL04LA126Accident · Serious injuriesLimited investigationFinal reportPiper PA 32R-301 · Baxley, GAThe mechanical malfunction of the autopilot pitch servo, and the pilot's inability to maintain adequate control pressure to manually retrim the pitch attitude.NTSB ANC04FA063Accident · 1 fatalField investigationFinal reportBeech C-45H · Kodiak, AKThe pilot's failure to follow proper IFR procedures by not adhering to the published missed approach procedures, which resulted in an in-flight collision with tree-covered terrain. Factors contributing to the accident were a low ceiling, fog, rain, and the…NTSB NYC04LA140Accident · No injuriesLimited investigationFinal reportAviat Pitts S2B · Hamilton, OHThe pilot's failure to maintain directional control after experiencing a brake system malfunction during landing. Factors related to the accident were the malfunction of a landing gear brake as reported by the pilot, and the crosswind conditions.NTSB NYC04FA139Accident · 2 fatalField investigationFinal reportBeech 200 · Rupert, WVThe pilot-in-command's improper decision to continue VFR flight into IMC conditions, which resulted in controlled flight into terrain. Factors were the FAA Principle Operations Inspector's inadequate surveillance of the operator, and a low ceiling.NTSB MIA04LA096Accident · Serious injuriesLimited investigationFinal reportAeronca 11AC · Williston, FLThe pilot's failure to maintain airspeed (Vso) while maneuvering, which resulted in a stall/mush, an uncontrolled descent, and impact with terrain.NTSB LAX04LA240Accident · 1 fatalLimited investigationFinal reportPiper PA-25-235 · Peoria, AZthe pilot's failure to maintain a proper pitch attitude during tow operations and his failure to maintain an adequate airspeed, which resulted in an inadvertent stall/spin.NTSB LAX04CA238Accident · No injuriesData collectionFinal reportPiper PA-28-180 · Anza, CAThe pilot's misjudged altitude and speed, which resulted in an undershoot and a collision with a berm. Also causal was the control interference from the passenger.NTSB DEN04CA095Accident · Serious injuriesData collectionFinal reportNorthwing WS2 · Fort Collins, COA loss of engine power for undetermined reasons. Contributing factors include low altitude, and the lack of suitable terrain for a forced landing.NTSB DEN04CA092Accident · No injuriesData collectionFinal reportSchweizer 269C · Englewood, COthe settling with power situation encountered by the pilot. Contributing to the accident was the high density altitude.NTSB CHI04CA156Accident · No injuriesData collectionFinal reportYoukey Lancair 235 · Hays, KSThe pilot's inadequate compensation for wind conditions and his failure to maintain directional control of the airplane during the landing roll. Factors associated with the accident were the gusty crosswind, the runway marker sign, and the taxiway lights…NTSB CHI04CA150Accident · No injuriesData collectionFinal reportMaule MX7235 · Waukesha, WIThe pilot failed to maintain directional control and his inadequate compensation for wind conditions. Factors associated with the accident were the gusty crosswind and the concrete culvert that the airplane contacted.NTSB ATL04CA131Accident · No injuriesData collectionFinal reportCessna 172 · Meridianville, ALThe pilot's failure to maintain directional control during an attempted takeoff, which resulted in the on ground collision with the ground.NTSB ANC04LA068Accident · No injuriesLimited investigationFinal reportCessna 185 · Skwentna, AKThe pilot's inadequate compensation for wind conditions and his inadequate flare while landing, which resulted in a hard landing and collapse of the main landing gear. Factors associated with the accident were a downdraft, and rough and uneven terrain.NTSB ANC04LA064Accident · No injuriesLimited investigationFinal reportdeHavilland DHC-2 · Wasilla, AKThe pilot's failure to maintain directional control of the airplane during the landing roll, which resulted in a collision with a log. Factors contributing to the accident were a tailwind, a lack of brake pedals at the second pilot station, and the second…NTSB LAX04LA239Accident · 1 fatalLimited investigationFinal reportChampion 7AC · La Porte, CAthe student pilot's failure to maintain clearance with trees while flying along a mountainous ravine.NTSB FTW04WA173Accident · No injuriesForeign investigationBell UH-1B · Las Bocas, MexicoNTSB FTW04CA161Accident · No injuriesData collectionFinal reportRuehle Glastar · Lancaster, TXThe pilot's improper flare resulting in a hard landing.NTSB DEN04LA089Accident · 1 fatalLimited investigationFinal reportHispano Aviacion HA-200 · Pueblo, COThe pilot's failure to maintain adequate airspeed resulting in an accelerated stall at an altitude too low for recovery. A factor was the pilot's lack of experience in the aircraft make and model.NTSB CHI04CA153Accident · Minor injuriesData collectionFinal reportLuscombe 8E · Joliet, ILThe pilot's selection of unsuitable terrain for takeoff and the subsequent failure to maintain aircraft control during the encounter with the standing water. Contributing factors were the standing water and the soft runway condition.NTSB ATL04FA130Accident · 2 fatalField investigationFinal reportCessna 172F · Madisonville, TNThe pilot's failure to maintain airspeed while maneuvering on a touch and go landing resulting in a stall and collision with the ground.NTSB ATL04CA129Accident · No injuriesData collectionFinal reportCessna 172N · Dover, TNThe certified flight instructor initiated flight into thunderstorm activity that resulted in a loss of control and the subsequent collision with trees.NTSB SEA04LA104Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Jerome, IDThe pilot's failure to refuel the airplane resulting in fuel exhaustion and the loss of power during descent for landing. Factors contributing to the accident were the soft terrain and the forced landing site.NTSB NYC04WA148Accident · Serious injuriesForeign investigationPiper PA-42 · Reims, FranceNTSB FTW04LA159Accident · No injuriesLimited investigationFinal reportAyres S-2R · Eagle Lake, TXThe partial collapse of the left main landing gear as a result of a failure of the fuselage structure due to corrosion.NTSB FTW04IA160Incident · Minor injuriesIncident investigationFinal reportEmbraer EMB-135LR · Dallas, TXThe loss of pressure in Electrohydraulic Servovalve (EHSV) within the nose wheel steering manifold due to contamination in the C1 orifice of the valve, which resulted in an uncommanded turn of the nose wheel during landing rollout. A contributing factor was…NTSB IAD04LA024Accident · No injuriesLimited investigationFinal reportCessna 172P · Passaic, NJA total loss of engine power for undetermined reasons. A factor was the evasive maneuver on the ground.NTSB FTW04LA158Accident · Minor injuriesLimited investigationFinal reportRockwell International S-2R · Needville, TXThe loss of engine power and subsequent in-flight fire for undetermined reasons.NTSB DEN04TA088Accident · Serious injuriesFinal reportCessna C172P · Las Cruces, NMthe pilot's failure to maintain clearance from terrain and the improper go-around procedure. Contributing factors include the pilot's diverted attention, improper in-flight planning and decision making, pilot fatigue, the night conditions and the mesquite…NTSB CHI04CA154Accident · Serious injuriesData collectionFinal reportMooney M20C · Golden, MOThe pilot's failure to maintain directional control and his failure to maintain clearance from the trees. The trees were a contributing factor.NTSB CHI04CA152Accident · No injuriesData collectionFinal reportCessna 172N · Hillsboro, NDDirectional control not obtained/maintained by the pilot during landing roll.NTSB CHI04CA151Accident · No injuriesData collectionFinal reportGrumman-Schweizer G-164B · Hope, NDThe pilot's failure to maintain clearance from the tree branches during the aerial-application flight. A factor to the accident was the trees.NTSB SEA04LA102Accident · No injuriesLimited investigationFinal reportBell 206B · Prosser, WAThe pilot's failure to maintain clearance with the power lines while maneuvering.NTSB NYC04CA138Accident · No injuriesData collectionFinal reportCessna 152 · Elyria, OHThe student pilot's inadequate recovery from a bounced landing.NTSB LAX04LA235Accident · 1 fatalLimited investigationFinal reportHarold W Bruce RV-6 · Cloverdale, CAthe pilot's inadequate in-flight planning/decision and selection of the wrong runway, and his inadequate compensation for the gusting tail wind conditions, which resulted in a stall/mush.NTSB FTW04WA165Accident · 4 fatalForeign investigationPiper Pa-28 · Yamasa, Dominican RepublicNTSB ATL04LA128Accident · 1 fatalLimited investigationFinal reportGrover J3 Kitten · Mohawk, TNThe pilot's decision to perform aerobatic flight in an airplane with known deficiencies that resulted in the in-flight separation of the airframe and the uncontrolled collision with the ground.NTSB SEA04LA101Accident · Minor injuriesLimited investigationFinal reportPiper PA-18A · Trego, MTFailure to maintain clearance from trees during the initial climb.