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 NYC08FA180Accident · 2 fatalField investigationFinal reportPiper PA-32-260 · Cruso, NCThe pilot's inadequate preflight planning and inadvertent flight into instrument meteorological conditions with moderate to severe turbulence prevailing. Contributing to the accident were the instrument meteorological conditions and turbulence.NTSB DFW08CA141Accident · No injuriesData collectionFinal reportPiper PA-30 · Houston, TXThe pilot's loss of directional control during the landing. A contributing factor was the flight instructor's delayed remedial action.NTSB CHI08LA134Accident · Serious injuriesLimited investigationFinal reportCessna 150M · Palestine, ILThe loss of engine power due to carburetor icing. Contributing to the accident were the pilot's decision to conduct a low-power spiraling descent operation during conditions conducive to carburetor icing, and the weather that was conducive to carburetor icing.NTSB CHI08FA135Accident · 2 fatalField investigationFinal reportPiper PA-28-140 · Stevens Point, WIThe partial loss of engine power for undetermined reasons.NTSB CHI08FA133Accident · 2 fatalField investigationFinal reportBeech V35 · Bristol, OHThe loss of control during cruise flight in instrument conditions due to spatial disorientation.NTSB SEA08LA133Accident · Minor injuriesLimited investigationFinal reportThrush S-2R · Holtville, CAThe loss of oil pressure for undetermined reasons.NTSB SEA08CA131Accident · No injuriesData collectionFinal reportDiamond Aircraft Industries DA-40 · Lakeview, ORThe pilot's inadequate compensation for the wind conditions and failure to maintain directional control. Contributing to the accident was the crosswind was a factor.NTSB LAX08CA136Accident · Minor injuriesData collectionFinal reportA. Schleicher ASW 27-18 · Peoria, AZThe pilot's misjudged distance and altitude while on final approach to land. A factor contributing to the accident was a downdraft.NTSB DFW08CA138Accident · No injuriesData collectionFinal reportJihlavan KP-5 · Norfolk, NEA hard landing as a result of the pilot's improper flare. A contributing factor was the prevailing wind.NTSB DEN08WA088Accident · 1 fatalClass 5 · ForeignBeech BE-77 · Kilmovee, IrelandOn May 11, 2008, at 1547 UTC, a Beech BE-77, Ireland Registration EI-BHT, lost engine power on initial climb after takeoff and impacted terrain in a steep nose down attitude near Kilmovee, Ireland. The airplane was substantially damaged. The pilot on board…NTSB DEN08CA087Accident · No injuriesData collectionFinal reportCessna 172H · Brookshire, TXThe pilot's decision to duck under marked transmission lines and his failure to maintain clearance from the fence. Contributing to the accident was the marked transmission lines.NTSB CHI08FA128Accident · 3 fatalField investigationFinal reportEurocopter Deutschland EC 135 T2+ · La Crosse, WIThe pilot’s failure to maintain clearance from trees along the top of a ridgeline due to inadequate preflight planning, insufficient altitude, and the lack of a helicopter terrain awareness and warning system. Member Sumwalt did not approve this brief and…NTSB ANC08LA067Accident · No injuriesLimited investigationFinal reportde Havilland DHC-2 · Juneau, AKStructural damage to the airplane as the result of a birdstrike.NTSB ANC08CA066Accident · No injuriesData collectionFinal reportde Havilland DHC-2 · Talkeetna, AKThe pilot's inadvertent activation of the main landing gear brakes during the recovery from a bounced landing.NTSB SEA08LA128Accident · Serious injuriesLimited investigationFinal reportMoravan Zlin 50LX · Modesto, CAThe pilot failed to maintain clearance from terrain during a low-altitude maneuver at an airshow. Contributing to the accident was the task overload in the increased frequency congestion.NTSB SEA08CA132Accident · No injuriesData collectionFinal reportCessna 172 · Big Timber, MTThe student pilot's failure to maintain an adequate airspeed during landing which resulted in a stall.NTSB SEA08CA130Accident · No injuriesData collectionFinal reportBeech B19 · Burns, ORThe pilot's inadequate compensation for wind conditions and failure to maintain directional control. The shifting wind was a factor.NTSB SEA08CA129Accident · No injuriesData collectionFinal reportSchleicher ASK-21 · Tehachapi, CAThe pilot's inadequate preflight procedures and failure to check the spoiler control position, which resulted in the inadvertent deployment of the spoilers during takeoff. A contributing factor was the pilot's misinterpretation of the tow pilot's instructions.NTSB NYC08CA179Accident · Minor injuriesData collectionFinal reportCessna T182T · Newport, RIThe pilot's failure to maintain adequate airspeed during a go-around. Contributing to the accident was the pilot's improper weather evaluation and a tailwind.NTSB LAX08CA157Accident · No injuriesData collectionFinal reportPiper PA-34 · Blythe, CAThe pilot's failure to maintain directional control.NTSB ENG08RA026Incident · No injuriesForeign investigationFairchild Metro 23 · La Paz, Bolivia.NTSB DFW08LA140Accident · No injuriesLimited investigationFinal reportRobinson Helicopter R22 Marine · Austin, TXThe pilot's failure to maintain rotor RPM while maneuvering at a low altitude, which resulted in a loss of control.NTSB DFW08LA135Accident · Serious injuriesLimited investigationFinal reportBailey Varieze · Phillipsburg, KSThe pilots failure to maintain aircraft control during an emergency landing. Contributing factors were the reported smoke and prevailing gusty wind conditions.NTSB CHI08LA129Accident · No injuriesLimited investigationFinal reportCessna 208B · Ada, MIA loss of engine power for undetermined reasons.NTSB CHI08CA136Accident · Serious injuriesData collectionFinal reportSchleicher AS-K13 · Gregory, MIThe pilot's failure to adequately secure his handheld radio prior to takeoff, which resulted in a restriction of the flight control stick and loss of control. Contributing to the accident was the stall/mush flight condition encountered after the glider…NTSB CHI08CA131Accident · Minor injuriesData collectionFinal reportKuntz Kuntz 2000 GTS EFI · Dickinson, NDThe pilot's inadequate preflight weather evaluation and the unsuitable terrain encountered during the precautionary landing at night. Contributing to the accident was the pilot becoming lost after inadvertently encountering fog while en route, the night…NTSB ANC08CA064Accident · No injuriesData collectionFinal reportCessna 172 · Chugiak, AKThe pilot's failure to maintain control of the airplane during the landing roll. Contributing to the accident was an inadvertent ground loop/swerve.NTSB SEA08LA127Accident · 1 fatalLimited investigationFinal reportThorp T-18 · Kent, WAThe loss of engine power for undetermined reasons. Contributing to the accident were the lack of a suitable landing area and the pilot's failure to maintain an adequate airspeed while maneuvering in response to the loss of engine power.NTSB MIA08WA099Accident · No injuriesClass 5 · ForeignCessna 172M · Yurimaguas, PeruOn May 9, 2008, at 1506 eastern daylight time, a Cessna 172M, OB-1366, operated by Servicios Aereos Tarapoto E.I.R.A. SAETA as a business flight, had a total loss of engine power after take off and made a forced landing in a field. The airplane nosed over…NTSB LAX08LA135Accident · No injuriesLimited investigationFinal reportMaule M-5-235C · Oljato, UTThe pilot's failure to achieve a normal touchdown location and loss of directional control during landing roll out. Contributing to the accident were the runway's soft surface and short length.NTSB LAX08FA134Accident · 2 fatalField investigationFinal reportExtra Flugzeugproduktions-GMBH EA-300/L · Queen Creek, AZThe loss of aircraft control due to an undetermined rudder malfunction.NTSB DFW08TA137Accident · No injuriesFinal reportSchweizer 269D · San Antonio, TXThe pilot's failure to compensate for the excessive rate of descent on final approach. A contributing factor was the reported down draft.NTSB DFW08CA136Accident · No injuriesData collectionFinal reportPiper PA-36 · Thomas, OKThe disconnected throttle linkage resulting in the loss of engine power during takeoff-initial climb. A factor contributing to the accident was the muddy forced landing site.NTSB DCA08WA059Accident · 1 fatalForeign investigationBell 206 L-1 · Muanda, Congo - KinshasaNTSB CHI08CA127Accident · Minor injuriesData collectionFinal reportCessna 140 · Burlington, WIA loss of engine power for undetermined reasons. Contributing to the accident was the low altitude at the time of the loss of engine power.NTSB NYC08LA176Accident · 2 fatalLimited investigationFinal reportDesalvatore Al Lancair IV-P · Snow Hill, NCAn inadvertent encounter with icing conditions, resulting in a loss of aircraft control. Contributing to the accident was the pilot's inadequate preflight and in-flight decision making.NTSB DFW08LA139Accident · No injuriesLimited investigationFinal reportCommander AC-680 · Hope, ARThe pilot's failure to maintain control of the twin-engine airplane while landing. Contributing to the accident were the crosswind and partial loss of power on the right engine.NTSB DFW08LA133Accident · Minor injuriesLimited investigationFinal reportPiper PA-32R-300 · Emporia, KSA total loss of engine power due to fuel starvation as a result of a blocked fuel outlet caused by the peeling off of a previously approved fuel tank sealer.NTSB DFW08FA131Accident · 1 fatalField investigationFinal reportCessna 182 · Black Hawk, COThe loss of engine power due to induction icing. A contributing factor was the pilot's decision to continue flight in conditions favorable for structural and induction-system icing.NTSB DFW08CA132Accident · Minor injuriesData collectionFinal reportCessna C-210 · Pleasanton, TXThe pilot's failure to obtain the proper touchdown point resulting in an overrun. Contributing to the accident was the pilot's failure to abort the landing.NTSB CHI08CA126Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Naperville, ILThe pilot's failure to execute a go-around. Contributing to the accident was the pilot's excessive airspeed during touchdown, which resulted in the runway overrun.NTSB NYC08CA187Accident · No injuriesData collectionFinal reportCessna 172SP · Homestead, FLThe student pilot's improper flare. Contributing to the accident was the flight instructor's inadequate remedial action.NTSB MIA08LA097Accident · Serious injuriesLimited investigationFinal reportCessna 182L · Louisville, KYA total fatigue failure of the No. 5 piston during climb.NTSB LAX08CA132Accident · No injuriesData collectionFinal reportCessna 152 · Glendale, AZThe pilot's misjudged landing flare and inadequate recovery from a bounced landing.NTSB SEA08CA125Accident · No injuriesData collectionFinal reportCessna 152 · Redding, CAThe pilot's misjudged landing flare, which resulted in a hard landing.NTSB NYC08CA177Accident · No injuriesData collectionFinal reportBeech 65-A90 · Titusville, FLThe pilot's improper flare which resulted in a hard landing.NTSB LAX08LA137Accident · No injuriesLimited investigationFinal reportGrumman G-164 · Butte City, CAA total loss of engine power during takeoff due to fuel exhaustion as a result of the pilot's failure to verify the fuel quantity prior to flight.NTSB ANC08LA063Accident · Serious injuriesLimited investigationFinal reportShaffstall Kolb Firestar II · Concord, NCA loss of engine power for an undetermined reason, which resulted in a forced landing and collision with terrain.NTSB ANC08LA061Accident · Serious injuriesLimited investigationFinal reportChampion 7ECA · Soldotna, AKThe pilot's failure to remove the rudder gust lock prior to the flight.NTSB LAX08LA130Accident · Serious injuriesLimited investigationFinal reportGreco Drifter 912 · Homestead, FLThe pilot's failure to maintain adequate airspeed during a turn to the final approach leg of the traffic pattern, resulting in an accelerated stall.