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 MIA08CA140Accident · Minor injuriesData collectionFinal reportQuad City Ultralight Challenger II · Windslow Twp, NJThe pilot's inaccurate fuel consumption calculations which led to fuel exhaustion and subsequent loss of engine power.NTSB LAX08CA228Accident · No injuriesData collectionFinal reportSchweizer G-164B · Alturas, CAA total loss of engine power due to fuel starvation, which resulted from a fuel system contamination and a clogged fuel filter. Contributing to the accident was the rough terrain.NTSB NYC08LA247Accident · Minor injuriesLimited investigationFinal reportBoeing B75N1 · Culpeper, VAThe pilot's failure to maintain directional control of the airplane while landing in a quartering tailwind.NTSB NYC08LA245Accident · 1 fatalLimited investigationFinal reportGrumman G-164A · Pelham, GAA partial loss of engine power for undetermined reasons which led to a forced landing in unsuitable terrain.NTSB NYC08CA248Accident · No injuriesData collectionFinal reportCessna 172N · Edgewater, MDThe pilot's misjudged distance/speed during landing.NTSB DFW08CA189Accident · No injuriesData collectionFinal reportStinson 108-1 · Alliance, NEThe pilot's failure to maintain directional control on takeoff. Contributing to the accident was a lack of total experience.NTSB DFW08CA184Accident · No injuriesData collectionFinal reportWright Avid Flyer MK IV · Lake Jackson, TXThe loss of engine power due to a connecting rod failure.NTSB ANC08LA088Accident · No injuriesLimited investigationFinal reportCessna 150 · Manley Hot Spgs, AKThe pilot's selection of unsuitable terrain for takeoff, which resulted in a collision with a ditch during the takeoff roll. Factors contributing to the accident were low light conditions at dusk, and soft terrain.NTSB ANC08FA087Accident · 3 fatalField investigationFinal reportIversen Glastar SH-4 · Kenai, AKThe pilot's failure to maintain adequate airspeed during maneuvering flight, which resulted in an aerodynamic stall and uncontrolled descent to the ground. Contributing to the accident was the airplane's overgross weight condition.NTSB NYC08LA254Accident · No injuriesLimited investigationFinal reportSchweizer 269C-1 · Northumberland, VAThe pilot's inadequate remedial action after an inadvertent encounter with loss of tail rotor effectiveness.NTSB NYC08IA244Incident · No injuriesIncident investigationFinal reportAgusta A109E · Augusta, GAThe lack of available engine power and subsequent loss of rotor rpm due to the pilot’s departing with one engine at idle. Contributing to the incident was a corroded engine control wiring harness.NTSB LAX08LA226Accident · No injuriesLimited investigationFinal reportJonsson Sonerai · Hood River, ORThe pilot's failure to maintain directional control during the emergency landing roll with a tailwind. Contributing was the partial separation of the left aileron that prompted the pilot to attempt the emergency landing.NTSB DFW08CA183Accident · No injuriesData collectionFinal reportGrumman American AA-5A · Denton, TXThe pilot's inadequate fuel management, which resulted in fuel starvation and the subsequent loss of engine power.NTSB DFW08CA182Accident · No injuriesData collectionFinal reportAyres S2R · Baton Rouge, LAThe pilot's failure to maintain clearance from the transmission wire.NTSB CHI08CA192Accident · Minor injuriesData collectionFinal reportBell 47G-3B · Port Edwards, WIThe pilot failed to maintain control of the helicopter when he inadvertently flared the helicopter and the rotor rpm decayed as a result of sustaining bee stings during an aerial application flight. Contributing to the accidnet included the bees and the low…NTSB MIA08WA139Accident · 9 fatalClass 5 · ForeignRaytheon 99A · Puerto Montt, ChileOn July 10, 2008, about 1028 atlantic standard time, a Raytheon Aircraft Company 99A, Chilean registration CC-CFM, experienced an in-flight loss of control and crashed in an area of rising terrain approximately 1 mile north of La Paloma Airport (SCPF), Puerto…NTSB LAX08LA304Accident · No injuriesLimited investigationFinal reportBeech N35 · The Dalles, ORA collapse of the right main landing gear for undetermined reasons.NTSB LAX08CA224Accident · No injuriesData collectionFinal reportPiper PA-18A-150 · Camarillo, CAThe pilot's inadequate fuel management, which resulted in a total loss of engine power due to fuel starvation.NTSB LAX08CA223Accident · Minor injuriesData collectionFinal reportGrumman Acft Eng G-164B · Patterson, CAThe pilot's failure to maintain clearance from obstacles while maneuvering.NTSB OPS08IA010Incident · No injuriesIncident investigationFinal reportCessna 172 · Teterboro, NJProbable Cause The probable cause of this incident was the TEB ground controller's failure to direct N316AS to hold short of runway 24 when issuing taxi instructions to the aircraft as required FAA Order 7110.65, paragraph 3-7-2 (2a); Taxi and Ground Movement…NTSB NYC08WA243Accident · 1 fatalClass 5 · ForeignPiper PA-28-235 · Parnu, EstoniaOn July 9, 2008, at 1219 universal time coordinated, a Piper PA-28-235, Swedish registration SE-KUY, was substantially damaged when it impacted terrain during approach to Parnu Airport (EEPU), Parnu, Estonia. Visual meteorological conditions prevailed at the…NTSB MIA08LA138Accident · 2 fatalLimited investigationFinal reportColyaer SL Freedom S100 · Limestone, ALThe pilot's loss of aircraft control for undetermined reasons while making a water landing.NTSB LAX08LA221Accident · Minor injuriesLimited investigationFinal reportCessna 172RG · Moorpark, CAA partial loss of engine power due to the disconnection of the throttle control cable from the throttle arm due to the operator's improper maintenance. Contributing to the accident was unsuitable terrain for a forced landing.NTSB LAX08CA225Accident · No injuriesData collectionFinal reportCessna 182J · Metaline Falls, WAThe pilot's misjudged altitude and distance, which resulted in the airplane's failure to attain the proper touchdown point and a landing overrun. Contributing to the accident were trees and the short runway.NTSB LAX08CA222Accident · No injuriesData collectionFinal reportCessna 172R · Byron, CAThe pilot's failure to maintain directional control during the landing rollout.NTSB LAX08CA220Accident · Serious injuriesData collectionFinal reportDavid Jarrett Searey · Ennis Lake, MTThe pilot's failure to retract the landing gear prior to landing on the water.NTSB DFW08CA180Accident · Minor injuriesData collectionFinal reportMooney M20 · Rogers, ARThe loss of engine power due to fuel exhaustion as a result of the pilot's inadequate in-flight planning/decision.NTSB SEA08LA164Accident · No injuriesLimited investigationFinal reportEvektor-Aerotechnik SportStar · Arlington, WAThe pilot's failure to maintain directional control of the airplane during the takeoff roll in gusty conditions.NTSB NYC08FA242Accident · Minor injuriesField investigationFinal reportBeech V35B · Lancaster, PAA complete loss of engine power for undetermined reasons.NTSB LAX08LA212Accident · Serious injuriesLimited investigationFinal reportCessna 150F · Kalispell, MTA partial loss of engine power during initial climb due to fuel system contamination by a foreign substance. Contributing to the accident was the uneven terrain.NTSB LAX08CA227Accident · Minor injuriesData collectionFinal reportBeech E17B · Hubbard, ORThe pilot's improper use of brakes during the landing rollout.NTSB CHI08LA185Accident · No injuriesLimited investigationFinal reportTraxler John N Kitfox · Hartford, CTThe pilot's failure to compensate for crosswinds resulting in a loss of directional control while landing. Contributing to the accident was the pilot's lack of experience and training in tailwheeled airplanes.NTSB CHI08CA184Accident · No injuriesData collectionFinal reportHuebner RV6-A · Jerseyville, ILThe muddy, unsuitable terrain encountered during the landing.NTSB ANC08CA086Accident · No injuriesData collectionFinal reportPiper PA-32-301 · Pilot Point, AKThe pilot's selection of unsuitable terrain for takeoff.NTSB SEA08LA159Accident · Serious injuriesLimited investigationFinal reportMooney M20E · Big Creek, IDThe pilot's delayed decision to abort the landing and failure to achieve the proper touchdown point. Contributing to the accident was a high density altitude.NTSB MIA08LA134Accident · 1 fatalLimited investigationFinal reportDouglas A. Pohl Lancair IV-P · Hollywood, FLA loss of engine power for undetermined reasons. Contributing to the accident was the pilot's failure to maintain aircraft control which resulted in an aerodynamic stall.NTSB MIA08CA136Accident · No injuriesData collectionFinal reportSchleicher ASK-21 · Elmira, NYThe glider pilot's misjudged distance/altitude while soaring.NTSB LAX08CA243Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Canyon City, ORThe pilot's failure to maintain directional control. Contributing to the accident was the gusting tailwind.NTSB LAX08CA219Accident · No injuriesData collectionFinal reportTallent, Chris M. Putts Special · Sumter, SCthe pilot's failure to maintain the proper glideslope and clearance from obstacles. Contributing to the accident was the pilot's limited experience in the airplane type.NTSB DCA08RA078Accident · 2 fatalForeign investigationBoeing 747-200FM · Madrid, ColombiaOn July 7, 2008, at 0357 local time, a Boeing 747-200FM, N714CK, operated by Kalitta Air as Centurion Airlines flight 164, was destroyed during a forced landing in Madrid, Cundinamarca, Colombia, shortly after taking off from El Dorado International Airport…NTSB CHI08IA182Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas MD-81 · St. Louis, MOThe inadvertent partial inflation of the evacuation slide within the tailcone during takeoff and subsequent binding of the elevator control cables. The partial inflation resulted from the tailcone evacuation slide cover failing to be secured to the floor…NTSB SEA08LA160Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · East Carbon, UTThe pilot's inadequate in-flight planning and decision to continue flight into a canyon area with questionable aircraft performance. Contributing to the accident was the lack of suitable terrain for the precautionary landing and a high density altitude…NTSB OPS08IA008Incident · No injuriesIncident investigationFinal reportBoeing 737-300 · New York, NYThe probable cause of this incident was JFK air traffic control tower non-compliance with FAA separation requirements for operations on non-intersecting runways where flight paths intersect, and poor judgment by the LC2 controller in clearing LAN533 for…NTSB LAX08LA217Accident · No injuriesLimited investigationFinal reportLancair LC41-550FG · Hailey, IDThe loss of directional control while taxiing due to the failure of the right brake.NTSB LAX08CA214Accident · No injuriesData collectionFinal reportCessna 172F · Pomona, CAFuel exhaustion due to the pilot's inadequate preflight planning and his failure to refuel the airplane.NTSB DEN08LA121Accident · Minor injuriesLimited investigationFinal reportCessna 337G · Point Lookout, MOA fuel flange seal leak and water in the fuel resulting in a loss of engine power during takeoff. Contributing to the accident was an inadequate preflight.NTSB DEN08LA119Accident · 1 fatalLimited investigationFinal reportShannon Kevin RV-8 · Valera, TXThe pilot's failure to maintain adequate airspeed during a forced landing, which led to an aerodynamic stall, following a loss of engine power due to fuel exhaustion. Contributing to the accident was the pilot's mismanagement of fuel and the low altitude at…NTSB DCA08RA077Accident · 1 fatalForeign investigationMcdonnell Douglas DC-9-15 · Saltillo, MexicoimportNTSB CHI08CA181Accident · No injuriesData collectionFinal reportBeech C23 · Schaumburg, ILThe pilot's inadequate compensation for the crosswind and his failure to maintain directional control during landing. Contributing to the accident were the gusting crosswind, and the embankment.NTSB CHI08CA178Accident · No injuriesData collectionFinal reportMooney M20K · Howell, MIThe collision with a deer during the takeoff roll. Contributing to the accident was the dusk light condition.