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 ANC06LA030Accident · 1 fatalLimited investigationFinal reportMooney M-10 · Salinas, CAThe pilot's continued flight into known adverse weather, and his failure to maintain sufficient airspeed, which resulted in a loss of control and an inadvertent stall/spin during cruise flight. Factors associated with the accident are a low ceiling with…NTSB ANC06LA029Accident · 1 fatalLimited investigationFinal reportCooper Harmon Rocket ll · McKittrick, CAThe pilot's failure to maintain altitude/clearance while performing intentional low altitude aerobatic flight maneuvers. Factors associated with the accident are the low altitude aerobatic flight maneuvers.NTSB MIA06RA070Accident · 5 fatalForeign investigationCessna 208B · Cuenca, EcuadorNTSB ANC06CA036Accident · No injuriesData collectionFinal reportCessna 172S · Prescott, AZThe pilot's improper recovery from a bounced landing, which resulted in structural damage to the firewall and fuselage.NTSB OPS06IA007Incident · No injuriesIncident investigationFinal reportBoeing 737-300 · Chicago, ILThe probable cause of this incident was the ORD tower local controller's failure to provide sufficient separation between two aircraft departing intersecting runways. Contributing to the incident was the ORD local monitor's failure to monitor the situating…NTSB MIA06FA069Accident · 3 fatalField investigationFinal reportCessna 340A · Melbourne, FLThe pilot's failure to maintain adequate airspeed to avoid a stall during the final approach to land. Contributing to the accident was the pilot's impairment due to the use of a sedating antihistamine.NTSB ANC06LA028Accident · No injuriesLimited investigationFinal reportRobinson R-22B · Kailua-Kona, HIThe flight instructor's delayed remedial action while conducting hover practice with a student pilot, which resulted in the helicopter contacting the ground and rolling over. A factor contributing to the accident was an inadvertent dynamic roll over.NTSB SEA06CA069Accident · No injuriesData collectionFinal reportKearsley Exec 162F · Morgan, UTThe pilot's inadequate in-flight decision to attempt to hover out of ground effect above the kit manufacturers published recommendations. A factor was mountainous terrain.NTSB NYC06LA081Accident · No injuriesLimited investigationFinal reportGates Learjet 35 · Philadelphia, PAThe operator's inadequate maintenance of the fuel computer harness which resulted in engine surging and a subsequent loss of control by the flight crew during the takeoff roll.NTSB DEN06WA053Accident · 1 fatalForeign investigationMooney M-20K · San Bartelome, SpainNTSB CHI06LA095Accident · No injuriesLimited investigationFinal reportCessna 172G · Collins, MOThe pilot's inaccurate fuel consumption calculations that resulted in fuel exhaustion, and the loss of engine power during cruise flight. An additional cause was the pilot's improper in-flight decision to continue when he believed his fuel gauges were erratic…NTSB ANC06LA038Accident · No injuriesLimited investigationFinal reportMD Helicopters MD 900 · Mesa, AZThe manufacturer's inadequate design clearance of the main rotor blade grip pitch cases, which resulted in damage to the pitch cases when they contacted main rotor perimeter bolts during maneuvering flight.NTSB OPS06IA006Incident · No injuriesIncident investigationFinal reportAirbus Industrie 319 · Chicago, ILThe probable cause of the incident was the local controller's failure to ensure proper separation between Lufthansa flight 437 and Chautauqua (CHQ) flight 7826. Contributing was the failure of the local monitor to monitor the situation and advise the local…NTSB DFW06LA088Accident · 1 fatalLimited investigationFinal reportBeech C23 · Mena, ARThe pilot's continued flight into instrument meteorological conditions. Contributing factors were the mountainous terrain and the low ceilings.NTSB DFW06LA087Accident · 1 fatalLimited investigationFinal reportWeatherly 201B · Hondo, TXA loss of aircraft control for undetermined reasons.NTSB DFW06CA106Accident · No injuriesData collectionFinal reportCessna 172RG · Bridgeport, TXThe flight instructor's delayed remedial action to regain control of the airplane while landing in a crosswind, and the inadvertent retraction of the landing gear by the pilot receiving instruction while executing a go-around. A factor was the prevailing…NTSB DFW06CA089Accident · No injuriesData collectionFinal reportAero Commander AC50 · Shreveport, LAThe pilot's failure to execute a missed approach after losing visual contact with the runway, which resulted in a collision with approach lights. Factors were the dark night conditions and the fog.NTSB DEN06IA051Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas DC-9-82 · Denver, COthe captain's failure to follow existing company procedures for stabilized approach. **This report was modified on May 23, 2007.**NTSB ANC06WA042Accident · 1 fatalForeign investigationMD Helicopter MD 600 · Zama City, CanadaNTSB ANC06LA027Accident · Serious injuriesLimited investigationFinal reportPiper PA-18 · Dillingham, AKThe pilot's failure to maintain adequate airspeed while maneuvering for landing, which resulted in a loss of control and collision with snow-covered terrain. A factor contributing to the accident was an inadvertent stall.NTSB ANC06LA026Accident · 1 fatalLimited investigationFinal reportExtra Flugzeugbau 300S · Greenfield, CAThe pilot's failure to maintain adequate airspeed during the base leg to final approach phase of a VFR landing pattern, which resulted in an inadvertent stall and an uncontrolled descent. A factor contributing to the accident was the inadvertent stall/mush.NTSB NYC06CA080Accident · Serious injuriesData collectionFinal reportPiper PA23-250 · Morristown, NJThe pilot's premature shutdown of both engines, which resulted in a forced landing short of the runway. A factor was a landing gear malfunction indication for undetermined reasons.NTSB LAX06FA130Accident · 2 fatalField investigationFinal reportBeech F33A · Kingman, AZThe noninstrument rated pilot's cruise flight into instrument meteorological conditions, and his failure to maintain control of the airplane, which resulted in an uncontrolled descent, and an in-flight collision with terrain. Factors associated with the…NTSB DEN06LA050Accident · Serious injuriesLimited investigationFinal reportPiper PA-23-250 · Emporia, KSthe pilot's attempted flight into adverse weather conditions and improper in-flight planning which resulted in loss of control and subsequent impact with trees. Contributing factors were the pilot's delayed remedial action, the icing and dark night conditions.NTSB CHI06FA094Accident · 4 fatalField investigationFinal reportPiper PA34-200T · Branson, MOThe pilot's failure to maintain sufficient airspeed, which resulted in an inadvertent stall/spin while maneuvering to return to the departure airport for landing after declaring an emergency for unspecified reasons. Additional factors were the low cloud…NTSB MIA06LA068Accident · No injuriesLimited investigationFinal reportChampion 7EC · Zellwood, FLA loss of directional control due to the spring connecting the rudder to the tailwheel horn being detached.NTSB DEN06WA052Accident · 1 fatalForeign investigationPiper PA-28-180 · Bonndorf, GermanyNTSB ATL06IA054Incident · No injuriesIncident investigationFinal reportBombardier CL-600-2B19 · Asheville, NCThe improper installation of the pilot's windshield by company maintenance personnel, which resulted in flame and smoke in the cockpit, and subsequent emergency landing.NTSB ATL06CA055Accident · No injuriesData collectionFinal reportUrban Air UFM-10 · Lancaster, SCThe pilot's excessive climb angle during a go-around from a bounced landing which resulted in an inadvertent stall and subsequent in-flight collision with trees.NTSB SEA06FA068Accident · 2 fatalField investigationFinal reportBeech C99 · Butte, MTThe second pilot's failure to follow the published instrument approach procedure and the captain/PIC's inadequate supervision. Snow and mountain obscuration were factors.NTSB NYC06FA079Accident · 1 fatalField investigationFinal reportBeech 56TC · Winfield, WVThe pilot's inadequate preflight preparation to ensure an adequate supply of supplemental oxygen, and his inadequate in-flight planning and decision making, which resulted in exhaustion of his oxygen supply, and incapacitation from hypoxia during cruise…NTSB NYC06CA083Accident · No injuriesData collectionFinal reportSchleicher ASW-19B · Blairstown, NJA loss of lift, which resulted in a forced landing.NTSB MIA06LA067Accident · No injuriesLimited investigationFinal reportCirrus SR20 · Orlando, FLCatastrophic engine failure due to a low oil level brought about by excessive blow-by and cylinder detonation. Contributing factors in this accident were the inadequate instructions contained in Service Bulletin M89-9 and the ditch.NTSB ATL06LA053Accident · Minor injuriesLimited investigationFinal reportPiper PA28-180F · Easley, SCLoss of engine power for undetermined reasons which resulted in a forced landing and subsequent in-flight collision with non-suitable terrain.NTSB SEA06FA067Accident · 1 fatalField investigationFinal reportKaman K-1200 · Dayville, ORThe improper overhaul of the reduction gear box assembly and improper installation of the N1 seal and nut assembly lockcup by maintenance personnel, which resulted in failure of the reduction gear box and a total loss of engine power. A contributing factor…NTSB MIA06LA066Accident · Minor injuriesLimited investigationFinal reportLoehle P5151 · Lakeland, FLThe pilot's delay in initiating landing flare during a forced landing following a total loss of engine power. A factor was the lack of correct venting of the carburetor float bowl.NTSB CHI06CA093Accident · No injuriesData collectionFinal reportCessna 182G · Lebanon, INFailure by the flightcrew (dual student and flight instructor) to accurately determine the fuel quantity prior to flight, which resulted in fuel exhaustion. An additional cause was the flight instructor's inadequate supervision of the flight due to his…NTSB SEA06CA066Accident · No injuriesData collectionFinal reportCessna 182D · Sandpoint, IDThe pilot's failure to maintain clearance from an object (snow blowing equipment) while taxiing. The snow blowing equipment, and the pilot's failure to adequately maneuver the aircraft around snow berms were factors.NTSB MIA06LA064Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Sanford, FLA loss of engine power during takeoff-initial climb due to contamination (debris) lodged in the carburetor jet, which resulted in a forced landing and collision with trees.NTSB MIA06CA065Accident · No injuriesData collectionFinal reportCessna 172 · Leesburg, FLThe student pilot's failure to maintain directional control of the airplane during the landing roll resulting in collision with a taxiway sign.NTSB DFW06CA085Accident · No injuriesData collectionFinal reportCessna 182 · Houston, TXThe pilot's failure to maintain directional control while taxiing. A contributing factor was the gusty winds.NTSB DFW06CA084Accident · No injuriesData collectionFinal reportPiper PA-28-140 · Cherokee City, ARThe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB DEN06CA049Accident · No injuriesData collectionFinal reportStinson 108-1 · Limon, COthe pilot's failure to maintain aircraft control during the aborted landing resulting in an impact with a ditch. Contributing factors were the gusty wind conditions and the pilot's improper compensation for the wind conditions during landing.NTSB DEN06CA048Accident · No injuriesData collectionFinal reportEnstrom 280F · Peetz, COThe pilot's failure to maintain aircraft control while maneuvering resulting in an impact with terrain. Contributing factors were the gusty winds, downdrafts, and box canyon.NTSB CHI06LA099Accident · Serious injuriesLimited investigationFinal reportBoeing 757-222 · Omaha, NEAn inadvertent encounter with unforecast mountain wave turbulence during cruise flight. A contributing factor was the mountain wave (terrain induced) turbulence.NTSB DFW06FA083Accident · 2 fatalField investigationFinal reportBell 206L-1 · Patterson, LAThe improper installation of an engine fuel line fitting by other maintenance personnel, which resulted in a loose fitting and a loss of engine power during cruise flight. Factors associated with the accident are a tailwind, and the lack of a suitable site…NTSB CHI06LA092Accident · No injuriesLimited investigationFinal reportSaab-Scania 340B · Alpena, MIThe station agent's inability to maintain control of the stroller when he lost his balance exiting the airplane's cargo compartment, allowing it to be blown into the operating right propeller. A factor was the high, gusty winds.NTSB NYC06FA078Accident · 2 fatalField investigationFinal reportPiper PA-34-200T · Old Bridge, NJThe pilot's improper decision to conduct visual approach and landing in instrument meteorological conditions, and his failure to maintain adequate clearance from trees and terrain during the go-around. Factors in the accident were the low cloud ceiling and…NTSB LAX06FA129Accident · 2 fatalField investigationFinal reportBeech A36 · Santa Monica, CAThe failure of an aviation maintenance technician to properly torque and cotter pin the number 2 connecting rod bolts at their attach point to the crankshaft, which resulted in the separation of the connecting rod in flight, and complete power loss.NTSB ATL06LA052Accident · Minor injuriesLimited investigationFinal reportE Newton Newton RV-6A · Mooresville, NCThe collapse of the nose landing gear for undetermined reasons, which resulted in a nose over.