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 ANC06LA067Accident · No injuriesLimited investigationFinal reportCessna 182 · Chenega Bay, AKA loss of engine power for an undetermined reason while maneuvering at low level over a beach, which resulted in an in-flight collision with rough terrain and a nose over. A factor in the accident was the rough/uneven terrain.NTSB SEA06LA112Accident · No injuriesLimited investigationFinal reportde Havilland DHC-3T · Port Townsend, WAThe pilot's misjudgment of the airplane's height above the water during a precautionary landing which resulted in a hard landing. Contributing factors were glassy water conditions, fog, and the pilot's inadvertent VFR flight into IMC.NTSB DFW06CA158Accident · No injuriesData collectionFinal reportAyres S2R-600 · Childress, TXThe pilot's inability to maintain directional control while landing due to the failure of the rudder horn due to corrosion.NTSB DFW06CA149Accident · No injuriesData collectionFinal reportAir Tractor AT-401 · Garden City, TXThe pilot's improper in-flight planning resulting in the loss of engine power due to fuel exhaustion. A contributing factor was the lack of suitable terrain for the forced landing.NTSB DEN06CA081Accident · Minor injuriesData collectionFinal reportGrumman G-164B · Dighton, KSThe broken rocker arm boss causing the number 1 cylinder exhaust valve to stay closed and subsequently the engine failed. A factor contributing to the accident was the soft field the airplane set down in.NTSB ANC06LA066Accident · Minor injuriesLimited investigationFinal reportBell 206L-1 · Juneau, AKThe pilot's failure to maintain adequate altitude/clearance from terrain while maneuvering in adverse weather conditions. Factors associated with the accident are the pilot's decision to continue flight into adverse weather, fog, whiteout and flat light…NTSB NYC06LA142Accident · Minor injuriesLimited investigationFinal reportWeatherly 201B · Southampton, NJThe failure of the engine's supercharger, which resulted in a loss of engine power, and subsequent forced landing.NTSB NYC06FA133Accident · 4 fatalField investigationFinal reportPiper PA-28-236 · Manahawkin, NJThe noninstrument-rated pilot's inadvertent VFR cruise flight into instrument meteorological conditions, and his subsequent loss of aircraft control, which resulted in his exeeding the design stress limits of the airplane, and an in-flight separation of the…NTSB NYC06FA128Accident · Serious injuriesField investigationFinal reportEmbraer EMB-170 · Dulles, VAImproper servicing of the nose landing gear strut and the operator's inadequate maintenance procedure. A factor was the inadequate checklist provided to the flight crew by the operator.NTSB LAX06WA188Accident · 1 fatalForeign investigationBeech A36 · Bathurst Island, AustraliaNTSB CHI06CA143Accident · No injuriesData collectionFinal reportRobinson R44 · Stapleton, NEThe pilot not maintaining clearance fron the tree during landing. A factor was the tree.NTSB SEA06TA118Accident · No injuriesFinal reportCessna 206H · Aurora, ORThe failure of both the pilot of the aircraft traveling on a taxi lane and the operator of the automobile driving on a taxi lane to maintain an adequate visual lookout and their failure to see and avoid one another.NTSB SEA06CA108Accident · Minor injuriesData collectionFinal reportGrumman AA-1B · Bountiful, UTAn obstructed windshield which resulted in the pilot misjudging the distance/altitude during an emergency landing. An oil leak as a result of a leaking crankshaft seal was a factor.NTSB NYC06MA131Accident · 1 fatalMajor investigationFinal reportEurocopter EC-135P1 · Washington, DCThe operator's inadequate training program and the pilot's failure to maintain control of the helicopter following his inadvertent disabling of the No. 1 and then the No. 2 engine full authority digital engine control system.NTSB NYC06LA134Accident · No injuriesLimited investigationFinal reportClassic Waco YMF · Hagerstown, MDThe pilot's failure to maintain directional control during takeoff.NTSB NYC06CA135Accident · Minor injuriesData collectionFinal reportFlight Design Gmbh · Leesburg, VAThe pilot's improper remedial action to regain directional control after takeoff. A factor was the pilot's failure to maintain directional control after takeoff.NTSB MIA06CA113Accident · No injuriesData collectionFinal reportCessna 172R · Kissimmee, FLThe pilot's improper flare.NTSB LAX06LA187Accident · Serious injuriesLimited investigationFinal reportHunter Comp Air 6 · Minden, NVa loss of engine power due to an excessively rich mixture. The underlying reasons for the overly rich mixture were not determined. Also causal was the pilot's failure to maintain an adequate airspeed while maneuvering for a forced landing, which led to a…NTSB LAX06CA195Accident · No injuriesData collectionFinal reportWaco Classic YMF 5C · Holbrook, AZthe pilot's inadequate compensation for the crosswind condition and failure to maintain directional control of the airplane during landing, which resulted in a ground loop.NTSB DFW06WA148Accident · 1 fatalForeign investigationAir Tractor AT-802 · Molinicos, SpainNTSB DFW06WA147Accident · 3 fatalForeign investigationSchweizer 269D · Ciudad Juarez, MexicoNTSB DFW06IA145Incident · 1 fatalIncident investigationFinal reportBell 206L-3 · Grand Isle 43AAThe pilot's incapacitation and death due to pre-existing cardiac disease.NTSB DFW06CA144Accident · No injuriesData collectionFinal reportMooney M20J · Wichita Falls, TXThe pilot's failure to compensate for existing wind conditions. A contributing factor was the gusty crosswind.NTSB DFW06CA142Accident · Serious injuriesData collectionFinal reportBell 47G-4A · Sheridan, ARThe pilot's inadequate fuel management, which resulted in fuel exhaustion and a subsequent loss of engine power. A contributing factor was the lack of suitable terrain for the forced landing.NTSB DEN06LA080Accident · No injuriesLimited investigationFinal reportGarlick Helicopters OH- 58C · Muddy Gap, WYthe loss of engine power for reasons undetermined. Contributing to the accident was the low altitude and rough uneven terrain.NTSB CHI06FA141Accident · 1 fatalField investigationFinal reportCessna 210N · Ft. Thomas, KYThe pilot failed to maintain altitude/clearance with trees while attempting to return to the airport.NTSB CHI06CA142Accident · No injuriesData collectionFinal reportStys T-Bird Sport · West Bend, WIThe loss of engine power for undetermined reasons and the pilot's failure to maintain airspeed which resulted in a stall.NTSB ANC06LA064Accident · No injuriesLimited investigationFinal reportRobinson R44 · Skwentna, AKThe pilot's improper rigging of the external sling load, which allowed the suspended load/cargo cable to entangle and disable the tail rotor control, resulting in a loss of control during cruise and an in-flight collision with terrain.NTSB NYC06LA121Accident · Minor injuriesLimited investigationFinal reportEurocopter AS-350BA · Goshen, NYImproper maintenance of the hydraulic pump/coupling, which resulted in a failure of the hydraulic flight control system. Factors included the substandard materials of the hydraulic pump drive shaft and coupling, and the pilot's failure to maintain an adequate…NTSB NYC06CA158Accident · No injuriesData collectionFinal reportBoeing A75N1 · South Hill, VAThe pilot's failure to maintain directional control of the airplane during the landing, which resulted in a ground loop and a subsequent nose over.NTSB NYC06CA141Accident · No injuriesData collectionFinal reportMaule M-5-180C · Mount Pocono, PAThe disconnected tailwheel compression spring, which resulted in a loss of directional control.NTSB NYC06CA126Accident · No injuriesData collectionFinal reportPiper J3C · Old Town, METhe pilot's failure to maintain airspeed, which resulted in an inadvertent stall and subsequent impact with water.NTSB NYC06CA123Accident · No injuriesData collectionFinal reportChristen Industries A-1 · Linden, NJThe pilot's failure to maintain aircraft control during the engine run-up. Factor's in the accident were the pilot's diverted attention, and his failure to secure the airplane's left tire.NTSB LAX06LA185Accident · No injuriesLimited investigationFinal reportDiamond Aircraft Industries HK 36 TTC · Payson, AZpartial loss of engine power for undetermined reasons.NTSB DFW06CA146Accident · No injuriesData collectionFinal reportAir Tractor AT-802 · Tuckerman, ARThe loss of engine power due to water contamination in the fuel. A contributing factor was the lack of suitable terrain for the forced landing.NTSB DEN06CA079Accident · Serious injuriesData collectionFinal reportCessna T210N · Santa Fe, NMthe loss of engine power due to fuel exhaustion. Contributing factors were the pilot's inadequate preflight planning and failure to refuel the airplane.NTSB ATL06CA088Accident · No injuriesData collectionFinal reportBellanca 7ECA · Gadsden, ALThe pilot's failure to maintain a visual lookout,while maneuvering at a low altitude resulting in an in-flight collision with a powerline.NTSB ANC06CA065Accident · No injuriesData collectionFinal reportPiper PA-12 · Wasilla, AKThe pilot's inadequate compensation for a tailwind during the landing flare, which resulted in an in-flight collision with snow-covered terrain during an aborted landing. Factors contributing to the accident were a tailwind and rising terrain.NTSB SEA06CA107Accident · No injuriesData collectionFinal reportTaplin Avid Flyer · Grants Pass, ORThe partial loss of engine power for undertermined reasons, resulting in a forced landing and substantial damage to the airplane. A contributing factor was the transmission wire.NTSB NYC06LA127Accident · 1 fatalLimited investigationFinal reportSchweizer SGS 1-35 · Eighty Four, PAThe pilot's incapacitation, which resulted in a loss of aircraft control during approach, and subsequent collision with trees.NTSB NYC06LA124Accident · Minor injuriesLimited investigationFinal reportCessna C-172N · Vineyard Haven, MAThe pilot's improper preflight planning and improper fuel consumption calculations, which resulted in fuel exhaustion and a subsequent loss of engine power.NTSB NYC06LA122Accident · Minor injuriesLimited investigationFinal reportHughes 369HS · Mattituck, NYA loss of engine power due to undetermined reasons.NTSB NYC06CA125Accident · No injuriesData collectionFinal reportRobinson R-22 · Sanford, METhe flight instructor's inadvertent encounter with settling-with-power, which resulted in a hard landing, and subsequent roll-over. A factor in the accident was the tailwind.NTSB LAX06CA184Accident · Minor injuriesData collectionFinal reportRobinson R44 · Wailuku, HIthe pilot's inadequate compensation for the existing gusty wind conditions that resulted in his failure to maintain proper alignment with the landing area.NTSB ENG06WA041Incident · No injuriesForeign investigationAirbus A330 · Dubai, United Arab Emirates, United Arab EmiratesNTSB DFW06LA141Accident · Serious injuriesLimited investigationFinal reportRobinson R44 · Payne Springs, TXThe loss of engine power for undetermined reasons.NTSB CHI06LA149Accident · No injuriesLimited investigationFinal reportBeech A23 · Troy, MIThe improper flare and improper recovery from a bounced landing by the unknown pilot.NTSB CHI06LA138Accident · 1 fatalLimited investigationFinal reportHughes 269A · Berlin Center, OHThe pilot flew at a low altitude and failed to maintain clearance from the wire. A factor was the wire.NTSB SEA07CA138Accident · No injuriesData collectionFinal reportSchleicher ASW-24 · Williams, CAThe loss of thermal lift during cruise flight that resulted in a forced landing.NTSB LAX06FA186Accident · 3 fatalField investigationFinal reportCessna T182T · Burney, CAthe pilot's decision to continue VFR flight into instrument meteorological conditions and his failure to maintain clearance from mountainous terrain.