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 DFW07CA202Accident · No injuriesData collectionFinal reportPiper PA-24-180 · Taylor, TXThe loss of engine power due to fuel exhaustion as result of the pilot's inadequate in-flight planning/decision. Contributing factors were the lack of suitable terrain for the forced landing and the dark night.NTSB NYC07CA230Accident · No injuriesData collectionFinal reportGrenier Kitfox IV · Moultonboro, NHThe failure of both spark plugs in the number 3 cylinder which resulted in a partial loss of engine power.NTSB LAX07CA276Accident · No injuriesData collectionFinal reportCessna 177RG · Compton, CAthe pilot misjudged the flare resulting in a hard landing and loss of aircraft control.NTSB DFW07CA201Accident · Serious injuriesData collectionFinal reportUltra Magic M-56C · Bossier City, LAThe pilot's failure to arrest an excessive descent rate prior to ground contact, which resulted in a hard landing.NTSB DFW07CA200Accident · Minor injuriesData collectionFinal reportVans RV-7A · Vernon, TXThe pilot's failure to maintain control of the airplane while landing. A contributing factor was the prevailing tailwind.NTSB DEN07WA164Accident · 2 fatalForeign investigationPiper PA-28-181 · Airolo, SwitzerlandNTSB DCA07RA063Accident · 89 fatalForeign investigationBoeing MD-82 · Phuket, ThailandNTSB CHI07WA301Accident · No injuriesForeign investigationPiper PA-32-301 · Banbury, United KingdomNTSB CHI07CA314Accident · No injuriesData collectionFinal reportAeronca 7AC · Kent, OHThe inadequate compensation for wind conditions and the directional control not obtained/maintained by the pilot during landing. Contributing factors were the crosswind, gusts, and ditch.NTSB CHI07CA300Accident · Serious injuriesData collectionFinal reportCameron Balloons O-77 · Creston, IAThe pilot's inadvertent flight into adverse (high wind) weather conditions, which resulted in a hard landing. Contributing to the accident was the high wind encountered during the balloon flight and the barbed-wire fence.NTSB NYC07LA245Accident · No injuriesLimited investigationFinal reportBeech C-90 · Bloomingdale, GAA loss of engine power due to fuel exhaustion as a result of the pilot's improper preflight planning and preparation. Contributing to the accident was the pilot's reliance on inaccurate fuel gauges.NTSB NYC07FA228Accident · 1 fatalField investigationFinal reportBellanca 17-30A · Dallas, GAThe pilot's inadequate preflight inspection, which resulted in a loss of engine power during cruise due to fuel contamination.NTSB DFW07WA205Accident · No injuriesForeign investigationBoeing 737-200 · Guadalajara, MexicoNTSB DFW07LA199Accident · 1 fatalLimited investigationFinal reportMonocoupe 110SP · Utopia, TXThe pilot's loss of control while performing a low level inverted flight maneuver.NTSB DEN07FA158Accident · 2 fatalField investigationFinal reportEvektor-Aerotechnik a.s. SportStar · Erie, COThe flight instructor's failure to maintain sufficient airspeed during takeoff-initial climb to avoid a stall/spin. Contributing to the accident was the flight instructor's inadequate preflight planning, his failure to calculate the airplane's weight and…NTSB SEA07FA264Accident · 1 fatalField investigationFinal reportDeluca-Owl OR-71 · Reno, NVThe failure of the pilots of both aircraft to maintain an adequate visual lookout and clearance from one another during a low altitude aerial race.NTSB NYC07LA229Accident · Minor injuriesLimited investigationFinal reportIsrael Aircraft Industries Astra SPX · Atlanta, GAThe pilot's failure to initiate a missed approach and his failure to obtain the proper touchdown point while landing in the rain. Contributing to the accident were the operator's lack of standard operating procedures and the inadequate maintenance of the…NTSB NYC07LA227Accident · Serious injuriesLimited investigationFinal reportBeech A23-24 · West Chester, PAThe total failure of the left brake disc due to corrosion.NTSB LAX07LA278Accident · No injuriesLimited investigationFinal reportSkykits Savannah ADV · Lava Hot Spring, IDFailure of the pilot to maintain aircraft control during landing.NTSB LAX07LA274Accident · No injuriesLimited investigationFinal reportRobinson R22 Beta · El Monte, CAa failure of the main rotor drive system V-belts due to damage sustained when the alternator drive belt failed and pieces of that belt got between the main drive belts and their associated pulleys. A contributing factor was the uneven terrain encountered in…NTSB LAX07CA275Accident · Minor injuriesData collectionFinal reportCessna U206G · Fort Bragg, CAThe pilot's misjudged speed and distance, which resulted in a landing overrun of the runway.NTSB LAX07CA273Accident · No injuriesData collectionFinal reportRobinson R22 Beta II · Oakland, CAThe student pilot's failure to adequately compensate for the crosswind conditions and to maintain directional control.NTSB DFW07LA203Accident · No injuriesLimited investigationFinal reportAir Tractor AT 602 · Floydada, TXA leak in the outer ply of the BeCu bellows. This hole appeared to be the result of pitting corrosion, but the corroding agent was not determined.NTSB SEA07FA263Accident · 1 fatalField investigationFinal reportAero Vodochody L-39C · Reno, NVThe pilot's encounter with wake turbulence while maneuvering over a race course. Contributing to the accident was the low altitude at which the encounter occurred.NTSB SEA07FA262Accident · 3 fatalField investigationFinal reportBeech A-36TC · Burlington, WAThe pilot's decision to descend below the published minimum descent altitude (MDA), and his failure to maintain clearance from vertical objects during an instrument approach. Contributing to the accident were low ceilings, inadequate preflight planning, and…NTSB SEA07FA246Accident · 2 fatalField investigationFinal reportPiper PA-28-140 · Alsea, ORTerrain clearance was not maintained while maneuvering. A low altitude during the maneuver and hilly terrain were factors.NTSB SEA07CA261Accident · No injuriesData collectionFinal reportAviat A-1B · Grangeville, IDThe pilot's failure to maintain directional control during the landing roll. Factors include a ditch located between the runway and the taxiway.NTSB OPS07IA010Incident · No injuriesIncident investigationFinal reportLearjet 35 · Washington, DCThe probable cause of this incident was the IAD tower local controller's failure to ensure that the runway was free of all known ground vehicles, equipment, and personnel before permitting a departing aircraft to start takeoff roll. Additionally, the…NTSB NYC07FA226Accident · 1 fatalField investigationFinal reportPiper PA-32R-301 · Whitfield, ALThe pilot’s intentional flight into known thunderstorms.NTSB NYC07CA225Accident · No injuriesData collectionFinal reportPiper J3L-65 · Stow, MAA partial loss of engine power for undetermined reasons.NTSB NYC07CA224Accident · Minor injuriesData collectionFinal reportPiper PA-28R-200 · Tampa, FLThe pilot's misjudged altitude/distance, which resulted in a hard landing, prior to the runway.NTSB LAX07CA279Accident · No injuriesData collectionFinal reportCessna 172L · Helena, MTunexpected collision with birds on short final that damaged the airplane wing structure.NTSB CHI07CA313Accident · No injuriesData collectionFinal reportHasch Vans RV6 · Salem, OHThe loss of engine power due to the blocked cooling and induction systems because of the pilot in command's failure to remove the cowling covers before the flight. Factors were the pilot's misjudged landing glidepath, the pilot rated passenger's inability to…NTSB CHI07CA299Accident · No injuriesData collectionFinal reportSchweizer 300 CBI · Minneapolis, MNThe dual student's improper flare during the simulated autorotation, and the flight instructor's delayed remedial action.NTSB SEA07LA259Accident · 1 fatalLimited investigationFinal reportRose Peregrine · Reno, NVThe overspeed of the modified racing engine during takeoff that created an oil mist on the exhaust and smoke, and the pilot's failure to maintain a speed above stall speed (Vs) during his attempted emergency landing. Contributing to the accident was the…NTSB SEA07CA268Accident · No injuriesData collectionFinal reportMooney M20D · Placerville, CAThe pilot's failure to extend the landing gear prior to landing. A contributing factor was the pilots impaired performance.NTSB SEA07CA260Accident · No injuriesData collectionFinal reportRobinson R-22B · Long Beach, CAThe student pilot's loss of directional control while hovering, and the instructor pilot's inadequate remedial action while attempting to take control of the helicopter.NTSB NYC07CA231Accident · No injuriesData collectionFinal reportMooney M20C · Allentown, PAThe pilot's improper recovery from a bounced landing.NTSB MIA07CA151Accident · No injuriesData collectionFinal reportSchleicher ASW-24E · Morganton, NCThe failure of the pilot to maintain airspeed while turning base to final resulting in the left wing contacting the ground.NTSB LAX07FA272Accident · 1 fatalField investigationFinal reportGrumman American AA-5 · Joshua Tree, CAThe pilot's failure to maintain terrain clearance during descent. Contributing to the accident were dark night conditions and mountainous terrain.NTSB DFW07LA197Accident · Serious injuriesLimited investigationFinal reportRobinson Helicopter R22 Beta · Fort Stockton, TXThe failure of the v-belt drive system to the main rotor for undetermined reasons. Contributing to the accident was insufficient altitude to perform a successful autorotation.NTSB DFW07FA198Accident · 2 fatalField investigationFinal reportFairchild Hiller FH-1100 · Hosston, LAThe in-flight separation of the main rotor mast while in cruise flight following a mast bumping event. The reason for the mast bumping event was not determined.NTSB DEN07LA155Accident · No injuriesLimited investigationFinal reportBell 47G-3B-1 · Avondale, COThe pilot's failure to attain translational lift and his improper flare. A contributing factor in this accident was the sudden wind shift.NTSB DEN07FA157Accident · Serious injuriesField investigationFinal reportCessna 180 · Englewood, COThe pilot's failure to maintain control of the airplane during the force landing attempt resulting in a stall-spin and the subsequent impact with the ground. A factor contributing to the accident was the engine failure for undetermined reasons.NTSB CHI07CA298Accident · Minor injuriesData collectionFinal reportMaule M-4-220C · Keene, NDThe pilot's failure to maintain control of the airplane during takeoff due to the high crosswind condition. Contributing factors were the high, gusting crosswind, and the tree.NTSB CHI07CA297Accident · No injuriesData collectionFinal reportBoeing Stearman E75 · Gordon, NEThe pilot's failure to maintain directional control during the crosswind landing which resulted in the inadvertent ground loop.NTSB ATL07CA126Accident · No injuriesData collectionFinal reportRans RV-9A · Harvest, ALThe pilot's improper landing flare and touchdown.NTSB SEA07CA258Accident · Minor injuriesData collectionFinal reportBell 206-B2 · Rosamond, CAThe pilot's inadequate compensation for gusting variable winds encountered after landing. Factors include gusting, suddenly shifting winds, and a hangar near the spot where the helicopter had landed.NTSB SEA07CA256Accident · Minor injuriesData collectionFinal reportRogerson Hiller RH-1100 · Stanwood, WAThe pilot's failure to execute a go-around and his failure to reduce his groundspeed to zero prior to touching down on the rough/uneven terrain. Factors include the momentary restriction of a flight control, rough/uneven terrain, and a tailwind.NTSB NYC07CA222Accident · Minor injuriesData collectionFinal reportLancair IV-P · Alabaster, ALThe pilot's failure to attain the proper touchdown point.