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 LAX05LA163Accident · Serious injuriesLimited investigationFinal reportCessna 140 · New Cuyama, CAthe pilot's failure to properly use carburetor heat during conditions conducive to carburetor icing, which resulted in the loss of engine power. A factor in the accident was the unsuitable landing terrain.NTSB IAD05LA061Accident · Serious injuriesLimited investigationFinal reportSchneidhorst Slingshot · Lima, OHThe pilot's failure to maintain adequate airspeed, resulting in an inadvertent stall. A factor to the accident was the overheating of the powerplant which resulted in a partial loss of engine power.NTSB CHI05LA110Accident · Serious injuriesLimited investigationFinal reportCessna 150L · Buffalo Grove, ILA loss of engine power due to fuel exhaustion during approach, inadequate preflight planning/preparation by the certified flight instruction (CFI), and the unsuitable terrain encountered by the CFI during the forced landing. An additional cause was the…NTSB MIA05CA100Accident · Minor injuriesData collectionFinal reportPiper PA-28-140 · Fort Pierce, FLThe pilot's inadequate in-flight planning/decision which resulted in fuel exhaustion. A contributing factor in the accident was the pilot's inadequate preflight planning/preparation to ensure an adequate fuel supply was available for the intended flight.NTSB LAX05LA160Accident · Minor injuriesLimited investigationFinal reportCessna 172RG · Grand Canyon, AZthe pilot-in-command's failure to properly lean the mixture, which resulted in a power deficiency, a degraded climb capability, and the inability to attain/maintain an adequate airspeed that led to a stall/mush condition while departing during high density…NTSB LAX05LA159Accident · Minor injuriesLimited investigationFinal reportBeech 23 · Tucson, AZa loss of engine power due to the fatigue fracture and separation of the mixture control cable. The fatigue crack resulted from inadequate installation techniques by unknown maintenance personnel.NTSB LAX05LA158Accident · Minor injuriesLimited investigationFinal reportChampion 7ECA · San Luis Obispo, CAa loss of engine power due to carburetor icing and the pilot's failure to use carburetor heat.NTSB ANC05LA073Accident · No injuriesLimited investigationFinal reportInterstate S-1A · Palmer, AKThe pilot's misjudged distance and speed, which resulted in an overrun during the landing roll, and subsequent nose over. Factors contributing to the accident were a tailwind and a short landing area.NTSB ANC05LA072Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Cordova, AKThe pilot's selection of unsuitable terrain for landing, and his failure to maintain control of the airplane, which resulted in a nose over during the landing roll. A factor contributing to the accident was uneven terrain.NTSB NYC05CA077Accident · Minor injuriesData collectionFinal reportPiper PA-28-180 · Portland, MEA loss of engine power due to the pilot's improper decision not to land and refuel resulting in fuel exhaustion.NTSB LAX05CA157Accident · No injuriesData collectionFinal reportCessna 182R · Camarillo, CAthe pilot's failure to maintain directional control during a touch-and-go landing. A contributing factor was the wet dirt at the runway edge.NTSB ATL05LA078Accident · 1 fatalLimited investigationFinal reportEarnest Jodel D-9 · Memphis, TNThe pilot's misjudgment of distance/altitude, and his failure to maintain adequate airspeed resulting in a stall and subsequent undershoot.NTSB SEA05LA094Accident · No injuriesLimited investigationFinal reportCessna 120 · Elk River, IDThe pilot's failure to maintain directional control during the landing roll. An inadvertent ground loop was a factor.NTSB LAX05LA151Accident · 1 fatalLimited investigationFinal reportGulfstream 695A · North Las Vegas, NVThe incapacitation of the pilot.NTSB LAX05TA156Accident · No injuriesFinal reportSikorsky S-70A · Calabasas, CAfatigue of the forward keeper due to known flaws in the manufacturing process.NTSB IAD05CA059Accident · No injuriesData collectionFinal reportCessna 152 · Millville, NJThe pilot's misjudgment of the airplane's distance to the restaurant sundeck.NTSB DFW05CA121Accident · No injuriesData collectionFinal reportBell 206L-1 · Georgetown, TXThe pilot's improper flare resulting in a hard landing.NTSB CHI05LA109Accident · No injuriesLimited investigationFinal reportPiper PA-31T · Bismarck, NDRupture of the hydraulic powerpak drain line which resulted in a loss of hydraulic fluid and the inability to properly lower the landing gear despite the pilot's execution of the emergency extension procedures. A contributing factor was the runway light…NTSB SEA06WA060Accident · 2 fatalForeign investigationFairchild Swearingen SA227-AC · Stratford, New ZealandNTSB SEA05FA092Accident · 2 fatalField investigationFinal reportCessna T210N · Kalispell, MTLoss of aircraft control during climb while in instrument meteorological conditions. Icing conditions was a factor.NTSB SEA05CA093Accident · No injuriesData collectionFinal reportJohnson Johnson Chris-Tena · Lebanon, ORThe loss of engine power on takeoff for an undetermined reason. A contributing factor was the lack of suitable terrain for the forced landing.NTSB MIA05CA121Accident · No injuriesData collectionFinal reportCessna 172SP · Clearwater, FLThe pilot's improper flare and recovery from a bounced landing.NTSB LAX05LA155Accident · No injuriesLimited investigationFinal reportBell 206L-1 · Peach Springs, AZa loss of power for undetermined reasons.NTSB DFW05LA115Accident · No injuriesLimited investigationFinal reportLancair Legacy · Nacogdoches, TXThe loss of engine power for undetermined reasons.NTSB SEA05FA090Accident · 1 fatalField investigationFinal reportCessna 170B · Portland, ORThe pilot's inability to control the airplane due to his incapacitation (carbon monoxide poisoning) from a deteriorated engine exhaust muffler. A contributing factor was the inadequate annual inspection by other maintenance personnel.NTSB NYC05CA079Accident · No injuriesData collectionFinal reportBoeing B75N1 · Culpeper, VAThe pilot's inadequate recovery from a bounced landing. A factor was the crosswind.NTSB MIA05WA102Accident · Minor injuriesForeign investigationCessna TU206F · Tela, HondurasNTSB LAX05LA154Accident · No injuriesLimited investigationFinal reportKittleson Quickie Q-200 · Santa Barbara, CAthe pilot's inadequate compensation for the crosswind condition and failure to maintain directional control.NTSB LAX05CA153Accident · Minor injuriesData collectionFinal reportAerotek Pitts S-2A · Tracy, CAthe pilot's inadequate compensation for the crosswind conditions and failure to maintain directional control, which resulted in a ground loop and nose over.NTSB ENG05RA011Incident · No injuriesForeign investigationBritish Aerospace BAE-146-200 · Verona, ItalyimportNTSB DFW05LA116Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164B · Fenton, LAThe loss of engine power due to fuel starvation as a result of blockage of the firewall fuel filter with an unknown contaminant. A contributing factor was the lack of suitable terrain for the forced landing.NTSB ANC05FA070Accident · 1 fatalField investigationFinal reportTaylorcraft F-19 · Fairbanks, AKThe pilot's failure to maintain a minimum airspeed during a low-altitude turn to return to the airport, and his improper in-flight decision to initiate a steep, low altitude turn, which resulted in an inadvertent stall/spin, and an in-flight collision with…NTSB NYC05LA087Accident · Serious injuriesLimited investigationFinal reportKolb Mark III · Clay Center, OHThe loss of engine power for undetermined reasons.NTSB NYC05CA078Accident · No injuriesData collectionFinal reportCessna 150F · China, METhe pilot's improper inflight decision to land in a field instead of a nearby airport, after encountering deteriorating weather conditions. A factor was the deteriorating weather conditions.NTSB LAX05LA152Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Yuba City, CAa partial loss of engine power due to multiple cracks in the number 7 cylinder. The reasons for the cracks were not determinedNTSB IAD05WA149Accident · No injuriesForeign investigationCessna 206 · Klagenfurt, AustriaNTSB DFW05WA114Accident · 1 fatalForeign investigationBell 407 · La Primavera, MexicoNTSB ATL05CA077Accident · No injuriesData collectionFinal reportBell 206L 1 · Cherokee, NCThe pilot's improper use of the helicopter flight controls during a hover that resulted in a dynamic rollover.NTSB ANC05CA067Accident · No injuriesData collectionFinal reportBellanca 7GCBC · Palmer, AKThe pilot's selection of unsuitable terrain for landing, which resulted in a loss of control during the landing roll, and a collision with willows and a creek bank. A factor associated with the accident was the soft landing area.NTSB DFW05LA113Accident · Minor injuriesLimited investigationFinal reportPiper PA-25-235 · Houston, TXA loss of engine power due to the pilot's inadequate preflight planning/preparation in detecting contaminated fuel. A contributing factor was the lack of suitable terrain for the forced landing.NTSB DFW05LA112Accident · Serious injuriesLimited investigationFinal reportBoeing 737-700 · Little Rock, ARAn encounter with moderate turbulence during cruise flight.NTSB SEA05WA102Accident · Minor injuriesForeign investigationKaman K-1200 · Korea, South KoreaNTSB SEA05LA089Accident · No injuriesLimited investigationFinal reportAeronca 0-58B · Kennewick, WALoss of engine power for undetermined reasons, which resulted in a forced landing and subsequent nose over. A factor was the unsuitable terrain.NTSB MIA05CA099Accident · No injuriesData collectionFinal reportPiper PA32-301 · Brooksville, FLThe pilot-in-command failure to maintain directional control during takeoff after landing, which resulted in the airplane exiting the runway.NTSB DFW05FA111Accident · 2 fatalField investigationFinal reportCessna 172 · Midland, TXThe pilot's failure to maintain airspeed which resulted in an inadvertent stall. A contributing factor was the low altitude.NTSB ATL05LA076Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Thomaston, GAThe unapproved repair of the tailwheel rudder arm assembly, which resulted in an overload failure during touchdown and subsequent loss of control of the airplane and on-ground collision with an object.NTSB ANC05LA065Accident · No injuriesLimited investigationFinal reportPiper PA-18-160 · Wasilla, AKThe pilot's selection of an unsuitable landing area, which resulted in a loss of control during the landing roll, and a collision with a ditch. A factor associated with the airplane was a leaking brake assembly and diminished braking efficiency.NTSB ANC05LA063Accident · No injuriesLimited investigationFinal reportCessna 185F · Anchorage, AKA total loss of engine power during descent due to a loose mixture control linkage, and the pilot/owner's failure to maintain the airplane's annual inspection schedule, which resulted in a forced landing in an area that contained power lines and trees.NTSB ANC05IA064Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas MD-11 · Anchorage, AKThe inadequate installation of the cockpit security door locking device, which resulted in smoke in the cockpit during normal cruise, and a precautionary landing. A factor associated with the incident was the manufacturer's insufficiently defined installation…NTSB SEA05CA088Accident · No injuriesData collectionFinal reportCessna 150L · Eureka, MTThe pilot's failure to adequately compensate for the wind conditions during the landing roll. Factors include a 10 knot crosswind, with gusts up to 15 knots, and a taxiway sign near the point where the aircraft exited the runway.