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 SEA06LA065Accident · Minor injuriesLimited investigationFinal reportKaman K-1200 · Dexter, ORThe pilot's failure to identify the overspeed of the helicopter's main rotors due to a turbine governor malfunction, and his failure to take the appropriate actions described in the Flight Manual's emergency procedures section. Factors include the malfunction…NTSB SEA06LA064Accident · No injuriesLimited investigationFinal reportSessi Midget Mustang SK-1 · Everett, WAThe pilot did not abort the takeoff and subsequently did not maintain aircraft control during the initial takeoff climb. The installation of the wrong propeller assembly and inadequate maintenance were factors.NTSB MIA06LA063Accident · Minor injuriesLimited investigationFinal reportPiper PA-32RT-300T · Baker, FLA loss of engine power due to an oil line leak and oil exhaustion. A contributing factor was the unsuitable terrain on which to make a forced landing.NTSB ATL06LA051Accident · Serious injuriesLimited investigationFinal reportEakle R Grandin Jr Talon XP · Auburn, ALThe pilot's failure to maintain airspeed which resulted in an inadvertent stall. A factor was the improper maintenance inspection of the engine fuel lines resulting in loss of engine power due to a loose fuel line and subsequent fuel starvation.NTSB ANC06LA025Accident · No injuriesLimited investigationFinal reportRobinson R44 · Ilimana, AKThe pilot's continued flight into adverse weather conditions, and his spatial disorientation and loss of control during a subsequent landing attempt. Factors associated with the accident are flat light and whiteout conditions, fog, and snow-covered terrain.NTSB LAX06CA127Accident · No injuriesData collectionFinal reportCessna 140 · Mesa, AZthe pilot's improper use of the flight controls during landing, which resulted in a nose over.NTSB LAX06CA128Accident · No injuriesData collectionFinal reportCirrus SR22 · Scottsdale, AZthe pilot's inadequate compensation for the wind conditions and failure to maintain directional control.NTSB DFW06WA100Accident · No injuriesForeign investigationRockwell Sabreliner · Cochabamba, BoliviaNTSB LAX06FA126Accident · 3 fatalField investigationFinal reportCessna 414A · Kahului, HIThe failure of the pilot to execute the published emergency procedures pertaining to configuring the airplane for single engine flight, which would have allowed him to maintain minimum controllable airspeed (Vmc) and level flight. The pilot's failure to…NTSB ATL06LA050Accident · Minor injuriesLimited investigationFinal reportCessna 210 · Jesup, GAThe loss of engine power due to the fatigue failure of the crankshaft, which resulted in a forced landing, and an in-flight collision with trees. A factor associated with the accident was the failure of other maintenance personnel to comply with the engine…NTSB DEN06CA047Accident · Minor injuriesData collectionFinal reportBoeing D75N1 · Santa Teresa, NMthe pilot's failure to maintain directional control during the landing. Contributing factors include the high airspeed, the improper recovery from a bounced landing, the crosswind, and the soft dirt.NTSB ATL06LA049Accident · No injuriesLimited investigationFinal reportErcoupe E · Wetumpka, ALThe failure of the No. 2 exhaust, and intake valves for undetermined reasons, which resulted in a loss of engine power during cruise flight and damage to the airplane during the subsequent forced landing.NTSB SEA06WA063Accident · 1 fatalForeign investigationBeech C24R · Ribe, DenmarkNTSB LAX06CA125Accident · Minor injuriesData collectionFinal reportCessna 172N · Compton, CAcontrol interference by the student pilot during a go-around that resulted in an in-flight collision with power lines.NTSB DFW06WA080Accident · 2 fatalForeign investigationCessna 421C · Labiano, SpainNTSB CHI06FA090Accident · 2 fatalField investigationFinal reportBeech J35 · Holland, MIA lossof engine power due to fuel starvation as a result of the pilot's improper fuel system management and failure to select a tank containing fuel. A factor was the dark night conditions.NTSB CHI06CA098Accident · No injuriesData collectionFinal reportPiper PA-28-180 · Holly, MIA loss of engine power due to undetermined reasons. Factors associated with the accident were the guard rail and the ditch which the airplane contacted during the forced landing.NTSB NYC06CA077Accident · No injuriesData collectionFinal reportCessna 172S · Atlantic City, NJThe pilot's failure to obtain a proper touchdown point, which resulted in an overrun of the runway.NTSB DFW06LA078Accident · 1 fatalLimited investigationFinal reportCessna C-37 · Fittstown, OKThe loss of engine power due to a cracked cylinder head. A contributing factor was the lack of suitable terrain available to the pilot for the forced landing.NTSB CHI06WA097Accident · 1 fatalForeign investigationMooney M-20K · Sachsen, GermanyNTSB ANC06LA024Accident · No injuriesLimited investigationFinal reportCessna 185 · Ely, NVThe pilot's inadequate compensation for a quartering tailwind while taxiing, which resulted in a loss of control and an on ground encounter with terrain. A factor in the accident was the quartering crosswind.NTSB SEA06CA061Accident · No injuriesData collectionFinal reportPiper PA-18 · Saint Paul, ORThe pilot's failure to maintain a proper glide path on final approach to landing resulting in a nose over. A factor was the loose gravel/sandy condition.NTSB MIA06CA060Accident · Minor injuriesData collectionFinal reportLet L13 AC Blanik · Zephyrhills, FLThe pilot's encounter with downdraft.NTSB ENG06WA026Incident · No injuriesForeign investigationAirbus Industrie A320 · Dublin, IrelandNTSB DFW06WA082Accident · Serious injuriesForeign investigationCessna 208B · Arecuna, VenezuelaNTSB DEN06LA046Accident · No injuriesLimited investigationFinal reportAviat Pitts S-2B · Severance, COfuel exhaustion and the pilot's failure to refuel the airplane. Contributing factors were the inaccurate fuel flow reading and the pilot's incorrect fuel consumption calculations.NTSB ATL06LA048Accident · Minor injuriesLimited investigationFinal reportJoel H Johnson Rans S-6ES Coyote II · Cartersville, GAThe loss of engine power during cruise flight for undetermined reasons, which resulted in an forced landing, on ground collision with a ditch, and nose over.NTSB ANC06LA022Accident · No injuriesLimited investigationFinal reportPiper PA-24 · El Cajon, CAThe student pilot's failure to maintain directional control during takeoff, which resulted in an on ground collision with a sign, and the collapse of the main landing gear.NTSB ANC06CA033Accident · No injuriesData collectionFinal reportChampion 7GCB · Fairbanks, AKThe pilot's failure to maintain directional control during the landing roll, which resulted in the airplane colliding with a snowbank and nosing over.NTSB SEA06CA062Accident · No injuriesData collectionFinal reportPiper PA-18A · Shady Cove, ORThe pilot's improper installation of the control stick during maintenance, which resulted in the control stick becoming disconnected during the initial takeoff climb, resulting in a loss of control and in-flight collision with the ground.NTSB SEA06CA059Accident · No injuriesData collectionFinal reportBeech V35B · Burns, ORThe pilot's failure to maintain clearance from the terrain during the takeoff sequence. Factors include his inadequate removal of snow and ice from the wings prior to takeoff, his improper decision to retract the landing gear before it had been positively…NTSB NYC06CA076Accident · No injuriesData collectionFinal reportPZL-Swidnik PW-5 · Hardwick, NJA loss of lift which resulted in a forced landing.NTSB MIA06LA062Accident · Serious injuriesLimited investigationFinal reportCessna 180 · Brooksville, FLAn in-flight loss of fuel for undetermined reasons which resulted in fuel exhaustion, a forced landing and damage to the airplane during the landing.NTSB MIA06LA061Accident · No injuriesLimited investigationFinal reportBell 206B · Naples, FLThe pilot's selection of an unsuitable area to make a precautionary landing which resulted in the helicopter rolling into a ditch.NTSB MIA06CA059Accident · No injuriesData collectionFinal reportPiper PA-18 · SanJuan, PRThe pilot's failure to maintain directional control during landing.NTSB DFW06WA079Accident · Minor injuriesForeign investigationAmerican Champion 8KCAB · Banjul, GambiaNTSB DFW06FA076Accident · 2 fatalField investigationFinal reportCessna 182N · Georgetown, TXThe pilot's failure to maintain airspeed during takeoff which resulted in a loss of control.NTSB DFW06CA081Accident · Minor injuriesData collectionFinal reportGrumman-Schweizer G-164B · Texarkana, ARThe loss of engine power due to a cracked cylinder. Contributing factors were the pilot's failure to maintain adequate airspeed.NTSB DFW06CA077Accident · No injuriesData collectionFinal reportCessna 182C · Gilliam, LAThe loss of engine power due to carburetor ice. Contributing factors were the pilot's failure to use carburetor heat and the lack of suitable terrain for the forced landing.NTSB DCA06WA027Incident · No injuriesForeign investigationBoeing MD-82 · Surabaya, IndonesiaNTSB CHI06CA091Accident · No injuriesData collectionFinal reportBalkema Stol Aircraft · Scotts, MIThe in-flight loss of engine power on downwind for undetermined reasons and the post-impact ground fire that burned the airplane while it was standing.NTSB ANC06LA023Accident · No injuriesLimited investigationFinal reportPiper PA-24 · La Vern, CAThe pilot's excessive taxi speed while turning, which resulted in an on ground collision with a taxiway light and the ground.NTSB ANC06LA021Accident · Minor injuriesLimited investigationFinal reportPiper PA-32R-300 · Winslow, AZThe presence of a foreign material/substance in the fuel system, which partially blocked the fuel flow divider, and resulted in a loss of engine power during takeoff-initial climb, and an emergency landing. A factor associated with the accident was unsuitable…NTSB NYC06IA075Incident · No injuriesIncident investigationFinal reportDassault Falcon 900EX · Teterboro, NJThe co-pilot's failure to obtain the proper touchdown point, which resulted in an overrun. Contributing were the gusty wind conditions, the failure of the flight crew to utilize the air brake after touchdown, and a partially contaminated runway.NTSB LAX06CA139Accident · No injuriesData collectionFinal reportBeech G35 · Flagstaff, AZthe pilot's failure to maintain an adequate clearance with obstructions while taxiing.NTSB MIA06LA058Accident · Minor injuriesLimited investigationFinal reportMooney M20J · Fort Pierce, FLImproper magneto installation by maintenance personnel, which resulted in the magneto detaching from the engine and subsequent loss of engine power.NTSB DEN06LA045Accident · No injuriesLimited investigationFinal reportPiper PA-32RT-300T · Manhattan, KSA loss of engine power due to the intermittent grounding of the left magneto "P" lead, causing the fuel controller to search and the engine to surge then lose power, and the pilot's failure to attain proper runway alignment. Contributing factors were the…NTSB ANC06LA032Accident · No injuriesLimited investigationFinal reportDouglas DC-3 · Beluga, AKThe pilot's failure to maintain altitude/clearance from trees on final approach, which resulted in an in-flight collision with trees.NTSB DCA06WA028Incident · No injuriesForeign investigationBoeing 717-200 · Paraburdoo, AustraliaNTSB CHI06LA088Accident · No injuriesLimited investigationFinal reportIrwin Sonex 2180 · Rockford, ILThe loss of engine power due to the restricted movement of the throttle cable during cruise flight. A factor in the accident was the trees contacted during the forced landing.