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 SEA07TA212Accident · No injuriesFinal reportHughes 369D · Omak, WAThe pilot's failure to maintain clearance from the surface of a pond that he was using as a water bucket refill site, which resulted in a tail rotor strike to the water's surface and a torsional overload failure of the tail rotor drive shaft.NTSB SEA07LA209Accident · Serious injuriesLimited investigationFinal reportCessna TU206F · Nampa, IDThe total loss of engine power for an undetermined reason. Factors include a power transmission line between the point were the aircraft lost power and the runway that the pilot was attempting to reach.NTSB NYC07CA172Accident · Minor injuriesData collectionFinal reportSchweizer SGS 1-26C · Windsor, VAThe pilot's failure to properly plan the approach to the airport, which resulted in an in-flight collision with a tree. A factor was the gusty wind conditions.NTSB LAX07LA225Accident · Minor injuriesLimited investigationFinal reportPiper PA-34-220T · Battle Mountain, NVThe pilot's failure to maintain directional control.NTSB DFW07WA166Accident · 1 fatalForeign investigationRobinson R22 Beta II · San Salvador, El SalvadorNTSB DFW07LA169Accident · No injuriesLimited investigationFinal reportBell 206L-3 · High Island 138The loss of control as result of the pilot's failure to maintain rotor RPM during takeoff.NTSB CHI07LA221Accident · Serious injuriesLimited investigationFinal reportGrumman G-164A · Moline, ILFatigue failure of the engine cylinder during cruise flight resulting in a loss of engine power. Additional causes were the pilot's failure to maintain sufficient airspeed and the resulting inadvertent stall during the forced landing. A contributing factor…NTSB CHI07CA226Accident · No injuriesData collectionFinal reportHamilton Rotorway Exec 90 · Harvey, NDThe pilot's failure to maintain clearance from the airport ramp area during the return for landing, which resulted in the landing skid dragging on the edge of the pavement and causing the helicopter to roll over.NTSB CHI07CA225Accident · Serious injuriesData collectionFinal reportRyan ST3KR · Coldwater, MIThe pilot's failure to maintain sufficient airspeed during the initial climb after takeoff, which resulted in an inadvertent stall/mush condition. A contributing factor was the low altitude at the time of the inadvertent stall.NTSB ATL07LA106Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Sussex, NJA loss of engine power for undetermined reasons.NTSB SEA07LA213Accident · No injuriesLimited investigationFinal reportBoeing A-75 · Spokane, WAThe locking/seizing of a main landing gear brake mechanism during the landing roll.NTSB SEA07FA208Accident · 2 fatalField investigationFinal reportGlobe GC-1B · Cottage Grove, ORThe partial/momentary loss of engine power during the takeoff initial climb for undetermined reasons, and the pilot's failure to maintain an airspeed above stall speed while maneuvering following the loss of engine power. Contributing to the accident was the…NTSB NYC07LA170Accident · No injuriesLimited investigationFinal reportLearjet 25 · St. Augustine, FLA loss of power on both engines for an undetermined reason.NTSB MIA07WA127Accident · Minor injuriesForeign investigationCessna 208B · Bolivar, VenezuelaNTSB MIA07LA124Accident · Minor injuriesLimited investigationFinal reportDennis M. Durgin Junior Ace · Dover-Foxcroft, METhe failure of the pilot to maintain airspeed following total loss of engine power due to fuel starvation, resulting in a stall/mush, uncontrolled descent, and in-flight collision with trees.NTSB MIA07CA125Accident · No injuriesData collectionFinal reportSchweizer SGS 1-26E · Big Flats, NYThe pilot's misjudged distance/altitude during approach resulting in collision with trees and the ground.NTSB DFW07WA168Accident · 1 fatalForeign investigationBeech BE-36TC · Tlajomulco, MexicoNTSB DEN07CA126Accident · No injuriesData collectionFinal reportFound Aircraft Canada FBA-2C2 · Crested Butte, COThe pilot's failure to maintain directional control during the landing roll.NTSB CHI07LA224Accident · No injuriesLimited investigationFinal reportBeech V35B · Rockford, ILA loss of engine power for undetermined reasons, which resulted in a forced landing. A contributing factor was the unsuitable terrain (corn field) encountered during the landing.NTSB NYC07LA171Accident · 1 fatalLimited investigationFinal reportMidget Mustang M-1 · Covode, PAA loss of engine power for undermined reasons.NTSB MIA07LA123Accident · No injuriesLimited investigationFinal reportLarry J. Cook Lancair 320 · Destin, FLThe separation of a portion of a propeller blade due to fatigue cracking which initiated in an area of corrosion that was not detected during propeller overhaul 10 flight hours before the accident.NTSB LAX07CA224Accident · Minor injuriesData collectionFinal reportCessna 150M · Woodland, CAAn in-flight collision with a bird. A factor in the accident was the deteriorated aircraft performance capability due to the increased drag that made continued flight impossible.NTSB DFW07LA170Accident · 1 fatalLimited investigationFinal reportHazen Fly Baby · Page, OKThe airplane's collision with wooded and mountainous terrain for undetermined reasons.NTSB DFW07LA167Accident · No injuriesLimited investigationFinal reportRotorway 162F · Stratford, OKThe loss of engine power due to a seized supercharger. A contributing factor was the lack of suitable terrain for the forced landing.NTSB DFW07LA165Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502 · Slaton, TXAn uncontained failure of the turbine engine's power section for undetermined reasons.NTSB DEN07LA135Accident · No injuriesLimited investigationFinal reportCessna T188C · Colby, KSThe pilot's failure to maintain directional control during the take-off roll resulting in a ground loop.NTSB DEN07LA124Accident · No injuriesLimited investigationFinal reportCessna A185F · Englewood, COThis case was revised 10/31/2007. Low compression in number 2 cylinder, which reduced the airplane's climb capability. Contributing factors in this accident were the high density altitude conditions, and the tree.NTSB CHI07CA251Accident · No injuriesData collectionFinal reportPiper PA-17 · Scribner, NEThe pilot's failure to maintain directional control during landing. A contributing factor was the gusting crosswind condition.NTSB CHI07CA233Accident · No injuriesData collectionFinal reportSchweizer SGS 1-35C · Northfield, MNThe pilot's failure to maintain adequate airspeed, which resulted in a stall during the off-airport landing. A factor contributing to the accident was the dirt/rock pile.NTSB CHI07CA223Accident · Minor injuriesData collectionFinal reportBush Caddy USA LSA · Chadron, NEThe pilot's failure to maintain control of the aircraft during landing. A contributing factor was the gusty, crosswind condition.NTSB CHI07CA222Accident · No injuriesData collectionFinal reportCessna 150J · Waldron, MOThe student pilot's failure to maintain directional control during the go-around. The cornfield was a factor.NTSB CHI07CA220Accident · Minor injuriesData collectionFinal reportSchweizer G-164B · West Liberty, IAThe pilot's inadvertent encounter with birds immediately after takeoff and the resulting loss of engine power. Contributing factors were the fence and ditch encountered during the overrun.NTSB DEN07LA122Accident · Serious injuriesLimited investigationFinal reportBeech C-45H · Longmont, COThe instructor pilot's improper preflight in that he failed to close the rocker box recovery system drain valves, resulting in a total loss of lubricating oil and subsequent oil starvation to both engines. A contributing factor was the trees.NTSB ANC07LA067Accident · No injuriesLimited investigationFinal reportLockheed 382G-44K-30 · McGrath, AKThe pilot's excessive rotation of the airplane during takeoff, which resulted in dragging the tail on the runway and substantial damage.NTSB SEA07CA207Accident · No injuriesData collectionFinal reportCessna 172S · Pahokee, FLThe student pilot's improper flare during the landing which resulted in a hard landing. The student pilot's failure to relinquish control of the aircraft, the flight instructors inadequate supervision and not being able to recover control of the aircraft from…NTSB NYC07CA169Accident · No injuriesData collectionFinal reportCessna 152 · Vero Beach, FLThe student pilot's failure to maintain directional control during landing, resulting in a runway excursion and subsequent nose over.NTSB MIA07CA126Accident · Minor injuriesData collectionFinal reportPhantom Sport XI · Anderson, ALThe failure of the unqualified person (pilot) to maintain airspeed during the initial climb, resulting in an inadvertent stall, uncontrolled descent, and in-flight collision with a residence.NTSB LAX07TA222Accident · Minor injuriesFinal reportAir Tractor AT-802A · Winnemucca, NVThe pilot's failure to maintain clearance with terrain while maneuvering.NTSB LAX07CA228Accident · No injuriesData collectionFinal reportDta Sari Combo FC 912 · San Luis Obispo, CAThe student pilot's improper flare, which resulted in a hard landing. Also causal was the instructor's inadequate supervision.NTSB SEA07LA210Accident · No injuriesLimited investigationFinal reportBeech E-33C · Laurel, MTThe overload failure of the nose gear retract brace (drag link) during the landing roll.NTSB SEA07CA205Accident · No injuriesData collectionFinal reportRobinson R22 · Bend, ORAn excessive descent rate during a simulated power-off autorotation, and the pilot's failure to initiate corrective action in time to keep the helicopter from impacting the terrain.NTSB NYC07CA165Accident · No injuriesData collectionFinal reportPiper J3C-65 · Uxbridge, MAA partial loss of engine power for undetermined reasons.NTSB DCA07RA059Accident · 199 fatalForeign investigationAirbus Industrie A320-233 · Sao Paulo, BrazilNTSB CHI07LA317Accident · Serious injuriesLimited investigationFinal reportAerostar International S81A · Custer, SDThe high wind during landing. Contributing to the accident was the encounter with adverse weather during the flight.NTSB SEA07TA202Accident · Minor injuriesFinal reportBell UH-1H · Benchmark, MTDense smoke/haze which restricted the pilot's visibility and the pilot's failure to maintain aircraft control during the emergency descent resulting in impact with terrain.NTSB SEA07CA206Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Ontario, ORThe pilot's improper recovery from a bounced landing and failure to maintain directional control during landing.NTSB SEA07CA200Accident · Minor injuriesData collectionFinal reportBell 206B II · Sheep Mountain, MTThe external load net, attached directly to the cargo hook without the use of a long line, oscillated and made contact with the tail rotor system while maneuvering.NTSB NYC07LA168Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · E.Stroudsburg, PAThe pilot's improper fuel management resulting in loss of engine power.NTSB DFW07CA163Accident · No injuriesData collectionFinal reportCessna 172M · Throckmorton, TXThe pilot's failure to maintain clearance from power transmission lines. A contributing factor was the prevailing dusk illumination.NTSB CHI07LA213Accident · 1 fatalLimited investigationFinal reportAir Tractor AT-402A · Laurel, IAThe pilot failed to maintain clearance with the upsloping terrain for undetermined reasons.