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 CHI07CA218Accident · No injuriesData collectionFinal reportCessna 188A · New Hartford, MOThe pilot's failure to maintain clearance from the tree line during the turn between aerial application passes. The low altitude, the downdraft encountered by the pilot, and the trees were contributing factors.NTSB CHI07CA217Accident · No injuriesData collectionFinal reportChrapczynski M1 Midget Mustang · Elyria, OHThe pilot's failure to maintain proper glide speed during the forced landing after takeoff, which resulted in an inadvertent stall/mush condition and a hard landing. A contributing factor was the loss of engine power after takeoff for undetermined reasons.NTSB CHI07CA215Accident · No injuriesData collectionFinal reportRotorway 162F · Heart, NDThe pilot inadvertently shut off the fuel pump switch which resulted in fuel starvation and the subsequent loss of engine power. An additional cause was the pilot's poorly executed autorotation/flare which resulted in a hard landing.NTSB SEA07LA196Accident · 1 fatalLimited investigationFinal reportNorth American F-51D · Camarillo, CAThe pilot's failure to maintain aircraft control during a go-around. Contributing to the accident was the pilot's lack of experience in the make and model of airplane.NTSB SEA07IA201Incident · No injuriesIncident investigationFinal reportCirrus Design SR22 · Reno, NVThe failure of the left turbocharger as a result of a production defect in the unit's compressor due to a machining process change by the manufacturer that was made without formal documentation or substantiation.NTSB SEA07FA199Accident · 2 fatalField investigationFinal reportCessna 182S · New River, AZThe pilot's inadvertent VFR flight into IMC and his ensuing failure to maintain aircraft control while in cruise flight. Contributing factors were the cloudy weather and the dark night conditions.NTSB SEA07CA221Accident · No injuriesData collectionFinal reportBritten-Norman BN-2A-20 · Stanley, IDThe pilot's failure to verify that the airplane was refueled, which resulted in a loss of engine power from both engines due to fuel exhaustion and a forced landing. A contributing factor was the lack of suitable terrain for the forced landing.NTSB SEA07CA198Accident · No injuriesData collectionFinal reportCessna 182B · Leadore, IDThe pilot's inadequate compensation for the gusty wind conditions and his failure to maintain aircraft control, which resulted in a loss of control and collision with terrain during the takeoff initial climb. A contributing factor was the gusty wind condition.NTSB SEA07CA197Accident · No injuriesData collectionFinal reportCessna 182S · Astoria, ORThe pilot's failure to maintain directional control during the landing flare/touchdown, resulting in an inadvertent swerve and collapse of the left main and nose landing gears.NTSB CHI07LA211Accident · Minor injuriesLimited investigationFinal reportMooney M20J · Eden Prairie, MNThe pilot's inability to maintain control of the airplane for undetermined reasons. Contributing to the accident were the embankment and the fence.NTSB CHI07LA208Accident · 1 fatalLimited investigationFinal reportAir Tractor AT-301 · Osceola, INThe pilot's failure to maintain clearance with the trees during the aerial application flight. Factors associated with the accident were the trees and the pilot's lack of experience in flying aerial application flights.NTSB CHI07CA216Accident · No injuriesData collectionFinal reportCessna 180 · Madison, SDThe tailwheel vibrations during the landing roll that resulted in the tailwheel spring disconnect. Directional control was not possible and the grassy terrain were factors.NTSB CHI07CA214Accident · Minor injuriesData collectionFinal reportGrumman G-164B · Sheldon, ILThe pilot's inability to maintain a proper rate of climb during takeoff. Factors associated with the accident were the pilot's failure to dump the chemical load and the ditch which the airplane contacted.NTSB CHI07CA209Accident · Serious injuriesData collectionFinal reportAir Tractor AT-301 · Lignite, NDThe pilot's poor in-flight planning and failure to maintain control of the airplane when he encountered his own vortex turbulence at a low altitude.NTSB ATL07CA105Accident · No injuriesData collectionFinal reportCessna 172S · Beverly, MAThe pilot's improper flare, which resulted in a hard landing and nose gear collapse. A contributing factor was the wind gust.NTSB SEA07TA203Accident · No injuriesFinal reportCessna TU206G · New Meadows, IDThe loss of engine power due to the loss of engine oil pressure following the oil pump's drive shaft failure for an undetermined reason. Contributing factors were the lack of suitable terrain for a forced landing and the rough/uneven terrain.NTSB SEA07FA195Accident · 1 fatalField investigationFinal reportYakovlev YAK-55M · Everett, WAThe pilot's inadequate preflight planning and inspection that led to oil exhaustion and a catastrophic engine failure. Also causal was the pilot's attempted operation of an aircraft with known deficiencies, and the lack of a current airworthiness inspection.…NTSB MIA07LA121Accident · 1 fatalLimited investigationFinal reportBurkhart Grob Flugzeugbau G102 Astir CS · Unionville, PAThe pilot's failure to maintain control of the glider for undetermined reasons.NTSB LAX07LA221Accident · No injuriesLimited investigationFinal reportBeech 58 · Chino, CAThe pilot's failure to ensure the landing gear selector handle was in the extended position prior to departure, which resulted in a premature retraction.NTSB LAX07LA220Accident · Serious injuriesLimited investigationFinal reportMurrin Frederick L Sopwith F1 · Greenville, PAa fuel starvation induced loss of engine power due to inadequate fuel system pressure. A factor in the accident was the pilot/builder's failure to adequately adjust the fuel system pressure.NTSB LAX07LA218Accident · Minor injuriesLimited investigationFinal reportClement Zenith Zodiac CH601 · Rosamond, CAA total loss of engine power during approach due to the improper idle screw/stop adjustment. A factor contributing to the accident was deteriorated fuel.NTSB LAX07FA219Accident · 2 fatalField investigationFinal reportPiper PA-28-181 · El Cajon, CAthe pilot's inadequate in-flight decision to attempt low altitude flight operations into a box canyon in mountainous terrain, and his failure to maintain an adequate airspeed while maneuvering to reverse direction, which led to an accelerated stall and spin.NTSB DFW07LA162Accident · No injuriesLimited investigationFinal reportAerospatiale SA-315 · Stuart, OKThe loss of engine power due to a clogged fuel tube. A contributing factor was the lack of suitable terrain for the forced landing.NTSB DFW07CA161Accident · No injuriesData collectionFinal reportRodgers Zodiac 601XL · Levelland, TXThe loss of engine power for undermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB DEN07CA121Accident · No injuriesData collectionFinal reportCessna 180 · Marble, COThe pilot misjudging his altitude and his failure to maintain control of the airplane, resulting in a hard landing. Factors contributing to the accident were the excessive descent rate, and the pilot's improper recovery from a bounced landing.NTSB CHI07CA210Accident · No injuriesData collectionFinal reportBoeing A-75N1 · Oelwein, IAThe pilot's failure to maintain directional control of the airplane during a landing roll. Factors associated with the accident was the gusty crosswind condition and the corn crop.NTSB ATL07LA104Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-161 · Gardner, MAThe pilot's failure to maintain control of the airplane during an aborted landing.NTSB SEA07CA194Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Jordan, MTThe pilot's failure to maintain aircraft control during a go-around. Contributing factors were the pilot's selection of unsuitable terrain for landing and the rough/uneven terrain.NTSB NYC07LA167Accident · No injuriesLimited investigationFinal reportOntario Avia. Hist. Soc. Fokker D VII · Geneseo, NYA loosening of the fuel filter, which resulted in a partial loss of engine power.NTSB LAX07LA216Accident · No injuriesLimited investigationFinal reportCessna 180A · Redding, CAFuel exhaustion due to the pilot's inadequate in-flight planning/decision concerning fuel system management and his failure to refuel while en route.NTSB LAX07GA217Accident · No injuriesFinal reportEurocopter France AS350 B3 · Paso Robles, CAa loss of control for undetermined reasons, which resulted in an uncommanded roll and subsequent collision with terrain. Contributing factors in the accident were the flying pilot's failure to request assistance from the second pilot in a timely manner and…NTSB CHI07LA207Accident · 1 fatalLimited investigationFinal reportWeatherly 620B · Wyoming, ILThe pilot's failure to maintain clearance with the power lines during the aerial application flight. Contributing to the accident were the power lines and the low altitude.NTSB NYC07LA166Accident · Minor injuriesLimited investigationFinal reportPiper PA-23-160 · Enterprise, ALThe designated examiner's improper decision to simulate an engine failure on short final approach, in conjunction with a short-field landing maneuver, and his inadequate remedial action. Contributing to the accident was the private pilot's inadvertent…NTSB MIA07LA120Accident · Minor injuriesLimited investigationFinal reportJohn D. Williams XT-912 · Newport News, VAThe pilot's failure to comply with FAA and engine manufacturer directives resulting in deterioration of fuel system components by fuel containing ethanol and blockage of the fuel filter by contaminants.NTSB MIA07CA119Accident · Serious injuriesData collectionFinal reportBoeing 777-232 · Atlanta, GAThe flight attendant's inadvertent misstep on a ladder and falling during pushback resulting in serious injuries.NTSB LAX07LA215Accident · No injuriesLimited investigationFinal reportCessna 172RG · Roche Harbor, WAThe pilot's failure to perform the emergency landing gear extension procedure prior to landing. A contributing factor in the accident was the failure of the electrical system.NTSB ENG07WA039Accident · 1 fatalForeign investigationAerospatiale 350B1 · Ballynacally, County Clare, Republic of Ireland, IrelandNTSB ATL07CA103Accident · No injuriesData collectionFinal reportSchweizer 269C-1 · Immokalee, FLThe pilot left the helicopter unattended with the engine operating which resulted in an inadvertent rollover.NTSB ANC07LA066Accident · No injuriesLimited investigationFinal reportBeech 58 · Northway, AKThe collapse of the landing gear during the landing roll for an undetermined reason.NTSB OPS07IA006Incident · No injuriesIncident investigationFinal reportBoeing 757-232 · Fort Lauderdale, FLThe probable cause of this incident was the United flightcrews' inadvertant entry onto an active runway.NTSB NYC07IA164Incident · No injuriesIncident investigationFinal reportPiper PA-31-350 · Orlando, FLThe mechanic's failure to secure the right engine cowling fasteners. Contributing to the incident was the pilot's inadequate preflight inspection.NTSB DFW07LA154Accident · Minor injuriesLimited investigationFinal reportWsk-Pzl Mielic M-18A · Tunica, MSThe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB DFW07CA156Accident · Minor injuriesData collectionFinal reportBell 47G-2A · Mercedes, TXThe pilot's failure to maintain clearance from the power transmission line.NTSB DEN07LA119Accident · Serious injuriesLimited investigationFinal reportCessna T206H · Gunnison, COAn inadvertent stall during takeoff/initial climb. Contributing factors in this accident were a partial loss of engine power for reasons undetermined, and high density altitude conditions.NTSB DEN07CA118Accident · Minor injuriesData collectionFinal reportJohnson F11C-2PJ · Deming, NMTotal failure of the top engine mount bolts and subsequent engine separation from the airframe.NTSB CHI07CA206Accident · No injuriesData collectionFinal reportGrumman G-164B · Alicia, ARA loss of engine power for undetermined reasons. Factors associated with the accident were the low altitude at which the loss of power occurred and the flooded rice field in which the airplane was landed.NTSB ANC07LA064Accident · No injuriesLimited investigationFinal reportChampion 7GCB · King Salmon, AKThe pilot's selection of unsuitable terrain for takeoff, which resulted in the right main landing gear collapsing during takeoff. Factors contributing to the accident were rough/uneven terrain, and the collapse of the main landing gear.NTSB NYC07MA162Accident · 5 fatalClass 1 · MajorFinal reportCessna 310R · Sanford, FLActions and decisions by National Association for Stock Car Auto Racing's corporate aviation division's management and maintenance personnel to allow the accident airplane to be released for flight with a known and unresolved discrepancy, and the accident…NTSB DFW07LA155Accident · 1 fatalLimited investigationFinal reportBoeing 737-232 · Tunica, MSGorund service personal's removal of the portable stairway prior to the main cabin door being secured. Factors were the high winds and heavy rain.NTSB DEN07CA117Accident · No injuriesData collectionFinal reportCessna 182R · Montpelier, VTThe pilot's improper flare and subsequent hard landing.