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 NYC06WA052Accident · 3 fatalForeign investigationRaytheon HS-125-700 · Kharkiv, UkraineNTSB NYC06LA050Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · Yonkers, NYA loss of engine power for undetermined reasons, which resulted in a ditching.NTSB NYC06CA049Accident · No injuriesData collectionFinal reportPiper PA-34-220T · Lawrence, MAThe pilot's improper flare and recovery from a bounced landing.NTSB MIA06FA039Accident · 3 fatalField investigationFinal reportRobinson R44 · Grand Ridge, FLThe pilot's continued flight into known adverse weather, and his impairment, which resulted in an in-flight collision with trees and terrain during cruise flight.NTSB LAX06WA077Accident · 5 fatalForeign investigationCessna U206 · Brisbane, AustraliaNTSB LAX06IA076Incident · No injuriesIncident investigationFinal reportSaab-Scania SF340B+ · Santa Maria, CAAn in-flight loss of control due to ice accreted in supercooled liquid droplets (SLD) conditions, and the flight crew's failure to maintain the specified minimum airspeed in icing conditions. Contributing to the accident was the flight crew's decision to…NTSB DEN06CA031Accident · Minor injuriesData collectionFinal reportCulver Cadet LCA · Alamogordo, NMthe pilot's failure to maintain aircraft control during the departure climb. Contributing factors included the gusty winds and the downdraft.NTSB ATL06FA030Accident · 1 fatalField investigationFinal reportPiper PA-28-180 · Peachtree City, GAThe pilot's failure to maintain sufficient altitude while performing an instrument approach in instrument meteorological conditions, which resulted in an in-flight collision with trees and terrain.NTSB ATL06CA032Accident · Minor injuriesData collectionFinal reportCessna T210L · Auburn, ALThe pilot's failure to attain the proper touchdown point during landing which resulted in an overrun and subsequent on ground collision with a fence.NTSB ATL06CA031Accident · Serious injuriesData collectionFinal reportPiper PA-23-160 · Phenix City, ALThe pilot's inadequate decision to continue VFR flight into IMC conditions, which resulted in a loss of engine power due to fuel exhaustion.NTSB ANC06LA015Accident · 1 fatalLimited investigationFinal reportCessna 180 · Seward, AKThe pilot's inadequate weather evaluation, which resulted in an in-flight encounter with low ceilings, turbulence, and downdrafts in cruise flight, and the pilot's failure to maintain altitude/clearance while maneuvering, which resulted in an in-flight…NTSB NYC06FA048Accident · 2 fatalField investigationFinal reportBeech D55 · Dawson, GAThe pilot's failure to maintain sufficient airspeed to preclude a stall, which resulted in an inadvertent stall and loss of control while circling to land. Factors associated with the accident were the pilot's inadequate in-flight planning and weather…NTSB DFW06CA045Accident · Minor injuriesData collectionFinal reportCessna 150L · Tulsa, OKThe pilot's improper preflight planning and preparation, which resulted in a loss of engine power due to fuel exhaustion.NTSB DEN06FA028Accident · 1 fatalField investigationFinal reportCessna 182D · Heber, AZthe pilot's failure to maintain altitude/clearance from terrain. Contributing factors included the pilot's lack of night flying experience and the dark night.NTSB LAX06FA075Accident · 3 fatalField investigationFinal reportBeech V35A · Valley Center, CAthe pilot's failure to maintain an adequate airspeed margin following a loss of engine power in the takeoff initial climb, resulting in a stall/spin. While the laboratory tests indicated the presence of an unknown biological contaminant in the fuel manifold…NTSB DEN06CA029Accident · Serious injuriesData collectionFinal reportCessna 182A · Hobbs, NMthe loss of engine power due to fuel exhaustion and the pilot's failure to visually verify the fuel quantity in the fuel tanks prior to departure. Contributing factors include the pilot's inadequate preflight, and the transmission wires.NTSB NYC06CA063Accident · Serious injuriesData collectionFinal reportGulfstream Aerospace G-200 · Baltimore, MDThe passenger's improper decision to get up from her seat while the airplane was taxiing. A factor was the inadvertent excessive application of the emergency brake.NTSB MIA06CA043Accident · No injuriesData collectionFinal reportAviat A-1B · Alexander City, ALThe failure of the pilot-in-command to maintain the proper rate of descent during approach for landing to the glassy water resulting in a hard landing and separation of the floats.NTSB LAX06LA073Accident · Minor injuriesLimited investigationFinal reportGrumman AA-5 · Boulder City, NVThe pilot's inadequate preflight inspection and failure to follow the airplane's checklist, which resulted in his failure to remove the gust lock prior to flight.NTSB LAX06CA074Accident · No injuriesData collectionFinal reportAvid Mark IV · California City, CAthe pilot's inadequate compensation for the crosswind and failure to maintain directional control of the airplane on takeoff.NTSB DFW06CA048Accident · Minor injuriesData collectionFinal reportBell 206L-4 · Washington, LAThe in-flight collision with a bird and the pilot's physical impairment (vision), directional control was not possible.NTSB DFW06CA047Accident · No injuriesData collectionFinal reportMooney M20J · Yoakum, TXThe pilot's misjudged distance/speed which resulted in an overrun.NTSB MIA06LA037Accident · No injuriesLimited investigationFinal reportCessna P206C · Lake Wales, FLThe loss of engine power during takeoff-initial climb due to fuel starvation, which resulted in a hard, off-airport forced landing.NTSB DFW06CA070Accident · No injuriesData collectionFinal reportBeech C23 · Eureka Springs, ARThe pilot's failure to maintain directional control while landing and his delay in aborting the landing.NTSB DFW06CA044Accident · No injuriesData collectionFinal reportChampion 7ECA · Fredericksburg, TXThe pilot's failure to maintain directional control on the landing roll-out. A factor was the crosswind.NTSB CHI06FA057Accident · 3 fatalField investigationFinal reportPiper PA-28-180 · La Vista, NEThe non-instrument rated pilot not maintaining aircraft control and not maintaining altitude/clearance from terrain during takeoff into instrument meteorological conditions. Contributing factors were the low ceilings, night conditions present, and the pilot's…NTSB ATL06FA029Accident · 2 fatalField investigationFinal reportCirrus Design SR22 · Sylva, NCThe pilot's continued VFR flight into IMC conditions resulting in a collision with mountainous terrain.NTSB SEA06CA034Accident · Minor injuriesData collectionFinal reportCessna 182G · Sweet Home, ORThe pilot's failure to maintain directional control during the takeoff roll, which resulted in the airplane exiting the paved runway surface, encountering muddy terrain and nosing over. Contributing factors were the night light condition and the muddy terrain.NTSB NYC06CA051Accident · No injuriesData collectionFinal reportPiper PA-22 · Jamestown, NYThe pilot's failure to maintain directional control during the landing rollout. Factors included the ice on the runway and the soft terrain.NTSB NYC06CA047Accident · Minor injuriesData collectionFinal reportCessna 180H · Greenville, NHThe pilot's inadequate pre-flight inspection, which resulted in water-contaminated fuel in the engine and subsequent engine failure.NTSB LAX06FA071Accident · 2 fatalField investigationFinal reportLearjet 35A · Truckee, CAThe pilot's inadequate compensation for the gusty crosswind condition and failure to maintain an adequate airspeed while maneuvering in a steep turn close to the ground.NTSB LAX06CA078Accident · No injuriesData collectionFinal reportWaco YMF-5C · Lihue, HIthe pilot's inadequate compensation for the crosswind condition and failure to maintain directional control of the aircraft on landing.NTSB SEA06LA033Accident · No injuriesLimited investigationFinal reportMcDonnell Douglas MD-83 · Seattle, WAThe ground personnel baggage handler failed to maintain clearance from the aircraft with cargo handling equipment during ground operations and inadvertently damaged the airplane's pressure bulkhead which subsequently decompressed during climb to cruise.NTSB LAX06CA070Accident · Minor injuriesData collectionFinal reportSocata TBM 700 · Lancaster, CAThe student's failure to maintain adequate airspeed, and the instructor's inadequate supervision and delayed remedial action, which resulted in a stall/mush.NTSB CHI06LA051Accident · Minor injuriesLimited investigationFinal reportPiper PA-31-350 · Marshall, MNA loss of engine power in both engines while on approach due to fuel exhaustion and the pilot's inaccurate fuel consumption calculations leading to him refueling the outboard tanks only.NTSB ATL06LA028Accident · Serious injuriesLimited investigationFinal reportCessna 177-RG · Locust Grove, GAThe total loss of engine power due to failure of the No.1 connecting rod bearing and separation of the No. 1 connecting rod.NTSB ATL06LA027Accident · No injuriesLimited investigationFinal reportPiper PA32-300 · Maiden, NCThe total loss of engine power due to the failure of the No. 5 main bearing due to overheating for undetermined reasons.NTSB ATL06CA047Accident · No injuriesData collectionFinal reportCessna 172 P · Wilmington, NCThe student pilot's improper landing flare which resulted in a hard landing.NTSB MIA06WA035Accident · 4 fatalForeign investigationPiper PA-23-250 · South Caicos, Turks & Caicos IslandsNTSB LAX06FA069Accident · 1 fatalField investigationFinal reportMcDonnell Douglas 369FF · Lihue, HIThe pilot's failure to maintain aircraft control while hovering out of ground effect during an external load operation. A contributing factor was the pilot's lack of experience in external load operations.NTSB DFW06WA046Accident · Serious injuriesForeign investigationBell 206L1 · Cantagallo, EcuadorNTSB DFW06LA041Accident · 1 fatalLimited investigationFinal reportBoeing A75N1 (PT17) · Fort Worth, TXThe pilot's failure to maintain airspeed, which resulted in an inadvertent stall/spin. Contributing factors were the reported loss of engine power for undetermined reasons and the low altitude maneuver.NTSB DEN06CA027Accident · No injuriesData collectionFinal reportMaule M-7-235 · Moriarty, NMthe pilot's failure to maintain directional control during the landing. Contributing factors included the pilot's inadequate in-flight decision making and the high velocity, gusty winds.NTSB CHI06CA052Accident · No injuriesData collectionFinal reportCessna 152 · Pelican Lake, WIThe pilot selecting an unsuitable landing area. Factors were the snow and ice covered lake.NTSB SEA06CA032Accident · No injuriesData collectionFinal reportPiper PA-28-151 · Emmett, IDThe pilot's inadequate in-flight decision by failing to refuel while en route, resulting in fuel exhaustion and the loss of power. A factor was the fence post.NTSB LAX06LA068Accident · 1 fatalLimited investigationFinal reportPiper PA-28-180 · Hopland, CAThe non-instrument rated pilot's failure to maintain clearance with terrain, which resulted in a controlled flight into terrain. Contributing factors were the dark night conditions and the low clouds.NTSB DFW06CA043Accident · No injuriesData collectionFinal reportMooney M20J · San Antonio, TXThe pilot's failure to maintain sufficient airspeed on takeoff, which resulted in an inadvertent stall and subsequent hard landing.NTSB DFW06CA042Accident · No injuriesData collectionFinal reportCASA 1.131E · McKinney, TXThe pilot's failure to maintain directional control and airspeed, which resulted in an inadvertent stall. A contributing factor was the pilot's helmet and goggles shifting while maneuvering.NTSB SEA06LA031Accident · Minor injuriesLimited investigationFinal reportCessna 208B · Portland, ORA partial loss of engine power for an undetermined reason during the initial takeoff climb resulting in an in-flight collision with objects.NTSB MIA06WA036Accident · 2 fatalForeign investigationPiper PA-23-260 · Cali, Colombia