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 CHI08CA296Accident · No injuriesData collectionFinal reportPiper PA28 · Gann Valley, SDThe pilot's inability to gain sufficient altitude during takeoff as a result of inadequate preflight planning.NTSB ANC08LA130Accident · No injuriesLimited investigationFinal reportMaule M-5-210C · Delta Junction, AKA total loss of engine power during takeoff due to the non-certificated pilot's inadvertent selection of the mixture control instead of the carburetor heat and his lack of training/qualification.NTSB SEA08CA211Accident · No injuriesData collectionFinal reportCessna 180 · Bluff, UTThe pilot's encounter with the rough, uneven, and eroded condition of the airstrip.NTSB ANC08LA127Accident · Serious injuriesLimited investigationFinal reportBell Helicopter Textron 206L-1 · Homer, AKThe pilot's failure to maintain clearance from power lines during an external load lift. Contributing to the accident was the pilot's lack of situational awareness.NTSB SEA08CA210Accident · No injuriesData collectionFinal reportMaule MX-7-2325 · Smith, NVThe pilot's excessive brake application during the landing roll, which resulted in a nose over.NTSB NYC08LA323Accident · No injuriesLimited investigationFinal reportBeech A200 · Bridgewater, VAThe pilot's decision to land with a tailwind on a short, wet runway, resulting in landing long and runway overrun. Contributing to the accident was the operator’s lack of standard operating procedures for test flights.NTSB MIA08CA202Accident · Minor injuriesData collectionFinal reportSchweizer 269C-1 · Titusville, FLThe flight instructor's delayed remedial action during a simulated autorotation.NTSB MIA08CA201Accident · Serious injuriesData collectionFinal reportCox Clyde H Fshr Aero Vsns Clbty · Tampa, FLThe pilot’s failure to maintain control of the airplane during takeoff due to inadequate maintenance.NTSB LAX08WA305Accident · 1 fatalForeign investigationBell 206 · Douglas Camp, Papua New GuineaOn September 25, 2008, at 1012 local time, a Bell 206L3, Papua New Guinea (PNG) registry P2-HBC, crashed in a remote area near Douglas Camp (PNG) under unknown circumstances while reportedly performing long line operations. The helicopter was operated by Heli…NTSB LAX08WA302Accident · Minor injuriesForeign investigationBell 407T · Talbot Bay, AustraliaNoneNTSB SEA08WA209Accident · 1 fatalClass 5 · ForeignLiberty Aerospace XL-2 · Hoxton Park, AustraliaOn September 24, 2008 at 0645 coordinated universal time (UTC), a Liberty XL-2, Australian registration VH-CZX, collided with the terrain near Hoxton Park, Australia. The pilot, the sole occupant, was killed. It is reported that the airplane collided in an…NTSB SEA08CA208Accident · No injuriesData collectionFinal reportRobinson R22 Beta II · Flagstaff, AZThe pilot's decision to attempt a takeoff in a high density altitude high gross weight condition that exceeded the takeoff performance capability of the helicopter. The pilot's failure to maintain adequate rotor rpm was also causal. Contributing factors were…NTSB DEN08IA160IncidentIncident investigationFinal reportRaytheon Cobra · Whetstone, AZA total off of engine power resulting from an overheated piston, and the pilot's subsequent failure to send a proper command to the UAS. Contributing to the accident was the operation of the engine at high power for an extended period with a lean fuel setting.NTSB CHI08LA286Accident · Minor injuriesLimited investigationFinal reportFlight Design Ctsw · Delaware, OHThe student pilot's failure to maintain directional control during landing.NTSB SEA08LA207Accident · Serious injuriesLimited investigationFinal reportSimpson Amphibious Trike · Lake Chelan, WAThe pilot's failure to maintain adequate airspeed during the initial climb, which resulted in an inadvertent aerodynamic stall. Contributing to the accident was the pilot's lack of experience in the float-equipped, weight-shift airplane.NTSB NYC08LA322Accident · 1 fatalLimited investigationFinal reportNagel SAL 2/3 P51 · Schenectady, NYThe pilot's failure to maintain adequate airspeed during the initial climb, which led to an aerodynamic stall.NTSB NYC08FA319Accident · 1 fatalField investigationFinal reportPiper PA-32 · Atlanta, GAA loss of aircraft control for undetermined reasons.NTSB OPS09IA001Incident · No injuriesIncident investigationFinal reportPeoria, ILThe tower local controller's failure to provide adequate separation between EGF4075 and SKW5961 that landed on intersecting runways.NTSB MIA08WA200Accident · Serious injuriesClass 5 · ForeignFokker F28-4000 · Quito, EcuadorOn September 22, 2008, about 1600 universal time, a Fokker F28-4000, HC-CDT, flight ICD-504, registered to and operated by Icaro Air, as a scheduled domestic passenger flight, aborted take off on runway 35 at Mariscal Surce Airport (SEQU), Quito, Ecuador. The…NTSB LAX08LA299Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Carlsbad, CAThe loss of engine power during takeoff for undetermined reasons.NTSB DEN08CA161AccidentData collectionFinal reportQuicksilver MX II Sprint · Killeen, TXThe operator's failure to maintain clearance from objects during the landing roll. Contributing to the accident was the operator's decision to operate a vehicle for which he/she was not certified.NTSB CHI08IA292Incident · No injuriesIncident investigationFinal reportBoeing 757-223 · Chicago, ILThe failure of an electrical relay due to eroded contacts and the flight crew's decision to continue a flight that was operating on battery power.NTSB NYC08LA317Accident · Serious injuriesLimited investigationFinal reportSorrell Skybolt · Williamstown, KYA loss of engine power due to oil starvation as a result of improper servicing (removal of preserving fluid) of the engine after it had been returned from storage.NTSB LAX08CA297Accident · Minor injuriesData collectionFinal reportBellanca 7GCBC · American Fork, UTThe pilot's selection of an inadequate altitude to enter a box canyon, which resulted in an in-flight collision with terrain.NTSB DEN08LA158Accident · Serious injuriesLimited investigationFinal reportCameron Balloons US N-77 · Plano, TXThe pilot's improper fuel management, resulting in fuel exhaustion and the subsequent hard landing.NTSB CHI08FA293Accident · 2 fatalField investigationFinal reportRobinson R44 II · Kenosha, WIThe pilots failure to maintain clearance from terrain resulting in an in-flight collision with a house. Contributing to the accident was the night instrument meteorological conditions (IMC) and the pilot's lack of experience of flying in IMC.NTSB SEA08LA206Accident · No injuriesLimited investigationFinal reportStearman C3-B · Stevenson, WAA loss of engine power due to fuel starvation from a piece of disintegrating gasket material that was blocking the fuel jet. Also causal was the failure of maintenance personnel to verify the condition of the gaskets when the carburetor was examined prior to…NTSB SEA08CA205Accident · No injuriesData collectionFinal reportDiamond DA40F · Provo, UTAn in-flight collision with a bird.NTSB NYC08CA316Accident · No injuriesData collectionFinal reportPiper PA28-140 · Carrabassett, METhe pilot's improper landing flare.NTSB MIA08LA197Accident · Serious injuriesLimited investigationFinal reportBerrie Kolb Mark III · East Haddam, CTThe pilot's improper preflight inspection of the airplane. Contributing to the accident was water contamination of the fuel.NTSB MIA08CA198Accident · No injuriesData collectionFinal reportMooney M20S · New Castle, PAThe on-ground collision with a deer during the takeoff roll. A contributing factor in the accident was the failure to completely secure the airport perimeter.NTSB DCA08MA098Accident · 4 fatalClass 1 · MajorFinal reportLearjet LR60 · Columbia, SCThe operator’s inadequate maintenance of the airplane’s tires, which resulted in multiple tire failures during takeoff roll due to severe underinflation, and the captain’s execution of a rejected takeoff (RTO) after V1, which was inconsistent with her…NTSB CHI08LA297Accident · Serious injuriesLimited investigationFinal reportPowrachute Pegasus · New London, WIThe pilot's loss of directional control during landing due to failure of the nose wheel support as a result of an inadequate weld.NTSB ANC08LA126Accident · No injuriesLimited investigationFinal reportPiper PA-19 · Palmer, AKA total loss of engine power for an undetermined reason.NTSB OPS08IA015Incident · No injuriesIncident investigationFinal reportBombardier CL-600-2C1 · Allentown, PAThe failure of both tower controllers to maintain awareness of the position of N736GV and ensure that the aircraft was clear of the runway before issuing a takeoff clearance to ASH7138.NTSB MIA08LA199Accident · No injuriesLimited investigationFinal reportEurocopter AS-350-BA · Linden, NJThe flight instructor’s delayed remedial action (flight control inputs) during a practice autorotation/run-on landing resulting in fracture damage to the main rotor system Starflex.NTSB MIA08LA196Accident · No injuriesLimited investigationFinal reportCessna 120 · Jesup, GAAn oil starvation-induced catastrophic engine failure due to the improper installation of the crankshaft expansion plug during engine overhaul.NTSB DFW08FA233Accident · 2 fatalField investigationFinal reportPiper Aerostar PA-60-602P · Kremmling, COThe pilot’s failure to maintain aircraft control, resulting in an aerodynamic stall and spin.NTSB DEN08LA159Accident · No injuriesLimited investigationFinal reportCessna 172RG · St. Louis, MOThe improper maintenance performed resulting in a jammed nose landing gear door preventing the extension of the nose landing gear.NTSB DEN08FA155Accident · 2 fatalField investigationFinal reportCessna 172L · York, NEThe student pilot's failure to maintain aircraft control, and the flight instructor's failure to take remedial action, for undetermined reasons.NTSB CHI08CA291Accident · No injuriesData collectionFinal reportCessna 172 · Wadsworth, OHThe pilot's excessive airspeed during the approach and landing and failure to perform a go-around. Contributing to the accident were the barricade and the down-sloping terrain at the end of the runway.NTSB CHI08CA289Accident · No injuriesData collectionFinal reportCub Crafters CC18-180 · Crookston, MNThe pilot's failure to maintain directional control during landing and the flight instructor's delayed remedial action.NTSB SEA08CA204Accident · No injuriesData collectionFinal reportGoetz RAF 2000 · Mulino, ORThe pilot's failure to maintain directional control during landing.NTSB NYC08CA315Accident · No injuriesData collectionFinal reportPiper PA-30 · Jefferson, GAThe pilot's failure to follow the airplane manufacturer's landing gear failure and emergency extension procedures. Contributing to the accident was a malfunction of the landing gear system for undetermined reasons.NTSB LAX08WA303Incident · No injuriesForeign investigationBoeing 757 · Cork, IrelandNTSB DFW08FA234Accident · No injuriesField investigationFinal reportCessna E162 · Douglas, KSThe airplane's inability to recover from an intentional spin, despite proper control inputs by the flight test pilot. Contributing to the accident was the failure of the airplane's ballistic parachute system to properly deploy.NTSB DFW08CA236Accident · No injuriesData collectionFinal reportPiper PA-32R-300 · Augusta, KSA loose oil line that resulted in a total loss of engine oil, causing the engine to cease.NTSB DFW08CA235Accident · No injuriesData collectionFinal reportGulfstream-Schweizer A/C Gulfstream · Patterson, LAThe loss of engine power due to fuel contamination. Contributing to the accident was the unsuitable muddy terrain for the forced landing.NTSB DEN08CA156Accident · No injuriesData collectionFinal reportCessna 177RG · Ellsworth, KSThe student pilot's failure to maintain directional control during the landing roll.NTSB CHI08IA294Incident · No injuriesIncident investigationFinal reportIndus T-211 Thorpedo · La Porte, INA loss of engine power due to fuel exhaustion as a result of siphoning from the fuel filler neck and cap. Contributing to the incident were the fuel over-servicing which resulted in the siphoning condition, and the ASTM standards which allowed for the fuel…