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 NYC06IA176Incident · No injuriesIncident investigationFinal reportEurocopter AS-350 BA · Philadelphia, PAA loss of hydraulic boost for undetermined reasons.NTSB NYC06CA174Accident · Minor injuriesData collectionFinal reportCessna 210G · Clayton, NYThe pilot's improper fuel tank selection, which resulted in fuel starvation, and subsequent loss of engine power.NTSB MIA06LA123Accident · Minor injuriesLimited investigationFinal reportBell 206B · Pompano Beach, FLThe pilot's improper landing flare during a precautionary landing. A factor in the accident was the unusual noise as a result of an improper repaired air conditioner compressor system.NTSB LAX06FA233Accident · 1 fatalField investigationFinal reportBellanca 14-19 · Arcata, CAThe pilot's failure to follow the prescribed instrument approach procedure and to maintain the proper glide slope and altitude/clearance from obstacles while on an instrument landing system approach, resulting in a collision with trees. Contributing to the…NTSB ENG06WA022Incident · No injuriesClass 5 · ForeignBoeing 747-200F · Amsterdam, NetherlandsOn July 16, 2006, at 1424 coordinated universal time, a Boeing 747-200F, N516MC, operated by Atlas Air, sufferend minor damage when the left main body gear tires burst during takeoff from runway 36L at Amsterdam/Schiphol Airport (EHAM). The airplane returned…NTSB DFW06FA184Accident · 2 fatalField investigationFinal reportPiper J3 · Walnut Ridge, ARThe pilot's failure to maintain airspeed and the subsequent stall. Contributing factors were the low altitude and impairment due to drugs.NTSB ATL06IA108Incident · No injuriesIncident investigationFinal reportDassault Mystere Falcon 900 · Greenville, SCThe malfunction of the anti-skid system SPAD controller during the landing roll, which resulted in failure of the anti-skid braking system, and a runway overrun.NTSB SEA06FA142Accident · 1 fatalField investigationFinal reportHawker Siddeley MK-58A Hunter · Hillsboro, ORLoss of aircraft control for undetermined reasons during the takeoff sequence.NTSB NYC06CA177Accident · No injuriesData collectionFinal reportBeech A36 · Somerville, NJThe pilot's continued flight into known adverse weather.NTSB MIA06LA122Accident · 1 fatalLimited investigationFinal reportCessna 320E · Wimauma, FLPilot's inadequate preflight planning and exceeding the weight and balance limitations of the airplane.NTSB DEN06LA100Accident · No injuriesLimited investigationFinal reportMaule M 6 180C · Kemmerer, WYthe pilot's loss of directional control during takeoff due to the improper rigging of the airplane's flap system by unknown maintenance personnel. A contributing factor was the high density altitude.NTSB DEN06CA101Accident · No injuriesData collectionFinal reportPiper PA-24-250 · Olathe, KSthe pilot's failure to extend the landing gear prior to landing.NTSB CHI06WA192Accident · 4 fatalForeign investigationPiper PA-46-310P · Marina di Campo, ItalyNTSB ATL06CA107Accident · No injuriesData collectionFinal reportCessna 182Q · Lafayette, GAThe pilot's improper flare which resulted in a hard landing.NTSB SEA06CA144Accident · No injuriesData collectionFinal reportPiper PA-11 · Turner, MTThe passenger's inadvertent activation of the airplane's brakes during the landing roll, resulting in the pilot's loss of control and subsequent nose over. A factor was the pilot's inadequate preflight planning/preparation by not briefing the passenger about…NTSB NYC06LA175Accident · Minor injuriesLimited investigationFinal reportEnstrom 280C · Danville, WVA partial failure of the override clutch assembly. A contributing factor to the accident was the manufacturer's inadequate inspection procedures of the override clutch assembly following a tail rotor strike.NTSB NYC06CA119Accident · Serious injuriesData collectionFinal reportCessna 182A · Plattsburgh, NYThe pilot's failure to utilize carburetor heat, which resulted in the formation of carburetor ice and subsequent engine failure. Factors included the carburetor icing conditions and trees in the forced landing area.NTSB MIA06LA121Accident · No injuriesLimited investigationFinal reportCessna T210 · Crestview, FLSpinning of the crankshaft No. 2 main bearing for undetermined reasons resulting in damage to the aft cheek of the No. 2 main bearing journal and fatigue failure of the crankshaft.NTSB LAX06LA232Accident · Minor injuriesLimited investigationFinal reportCessna R172K II · HagatnaThe failure of the number four connecting rod during takeoff-initial climb.NTSB LAX06LA231Accident · Minor injuriesLimited investigationFinal reportBeech C35 · Beckwourth, CAthe pilot's inadequate compensation for the crosswind condition and failure to maintain directional control during the landing roll.NTSB LAX06FA238Accident · No injuriesField investigationFinal reportLearjet 55 · Van Nuys, CAAn in-flight fire of undetermined origins.NTSB ENG06WA027Accident · No injuriesForeign investigationBell 206L · Maria Lankowitz, Austria, AustriaNTSB DFW06CA185Accident · No injuriesData collectionFinal reportCessna 120 · Rockwall, TXThe pilot's failure to compensate for existing wind conditions. A contributing factor was the prevailing crosswind.NTSB DEN06WA102Accident · 1 fatalForeign investigationCessna T310R · Saint Tropez, FranceNTSB DEN06LA099Accident · Serious injuriesLimited investigationFinal reportAeronca 7AC · Parker, COthe flight instructor's failure to maintain airspeed while maneuvering resulting in an inadvertent stall and subsequent impact with terrain. Contributing factors were the high density altitude, rising terrain, and improper in-flight planning.NTSB CHI06LA190Accident · 1 fatalLimited investigationFinal reportArmpriest Breezy · South Haven, MIThe inadvertent stall by pilot during climb following propeller blade damage from the compartment door separation after takeoff. The low altitude and airspeed not maintained by the pilot were additional causes. Contributing factors were the compartment door…NTSB ANC06CA091Accident · No injuriesData collectionFinal reportDahlstrom - Piel Emeraude CP-30 · Venice, FLThe pilot's inadequate compensation for crosswind conditions, which resulted in a loss of control during the landing roll. Factors associated with the accident were a crosswind, and an inadvertent swerve.NTSB NYC06LA179Accident · 1 fatalLimited investigationFinal reportCessna 172N · Pompton Lakes, NJImproper maintenance of the throttle shaft, which resulted in a partial loss of engine power during cruise flight, and subsequent impact with trees during a forced landing.NTSB LAX06LA230Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Pacoima, CAa loss of engine power due to the failure of maintenance personnel to tighten the top spark plugs, and install the leads for the ignition harness to the top spark plugs.NTSB ENG07WA032Accident · Serious injuriesForeign investigationGrumman AA-5B · Skane County, SwedenNTSB DFW06LA183Accident · No injuriesLimited investigationFinal reportGrumman AA-1 · Floydada, TXThe loss of fuel pressure and subsequent loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB DEN06WA098Accident · 3 fatalForeign investigationCessna 172N · El Rosario, SpainNTSB CHI06LA191Accident · No injuriesLimited investigationFinal reportCessna 120 · Laporte, MNThe inadequate preflight planning/preparation by the pilot and the loss of engine power due to fuel exhaustion during takeoff. A contributing factor was the runway marker.NTSB ATL06CA105Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Griffin, GAThe pilot's failure to maintain direction control of the airplane during the landing roll.NTSB DEN06LA097Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Holcomb, KSthe partial loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB CHI06CA189Accident · No injuriesData collectionFinal reportCessna 172R · Waterford, MIThe directional control not obtained/maintained, the inadequate compensation for wind conditions, and the go-around not performed during landing by the pilot. An additional cause was the lack of experience by the pilot. A contributing factor was the crosswind.NTSB ANC06LA101Accident · No injuriesLimited investigationFinal reportCessna 172E · Big Lake, AKThe pilot's failure to maintain altitude/clearance from a transmission line while performing a low altitude maneuver, which resulted in an in-flight collision with the transmission line.NTSB WAS06WA012Accident · 5 fatalForeign investigationLockheed 382 C130 · Kigoma, TanzaniaNTSB SEA06LA140Accident · Serious injuriesLimited investigationFinal reportCessna 182B · Big Creek, IDThe pilot's failure to maintain directional control of the aircraft during takeoff and initial climb out.NTSB DFW06CA182Accident · No injuriesData collectionFinal reportAir Tractor AT-502B · Marvell, ARThe pilot's failure to maintain clearance with terrain during takeoff.NTSB DEN06LA096Accident · Minor injuriesLimited investigationFinal reportBell 206L-3 · Taos, NMthe loss of tail rotor effectiveness during landing, and the pilot's delayed remedial action to counteract a right yaw, which resulted in a loss of directional control and collision with terrain. A contributing factor was the pilot's failure to perform…NTSB CHI06CA227Accident · No injuriesData collectionFinal reportCessna 172M · Cahokia, ILThe pilot's inadequate flare. A factor was the night light conditions.NTSB ANC06CA090Accident · Minor injuriesData collectionFinal reportSchweizer 300C · Titusville, FLThe failure of the certificated flight instructor (CFI) to maintain control of the helicopter, which resulted in an in-flight collision with terrain. A factor associated with the accident was the dual student's improper use of the cyclic trim.NTSB ANC06CA088Accident · No injuriesData collectionFinal reportCessna 206F · Fairbanks, AKThe pilot's inadequate weather evaluation, which resulted in the airplane encountering a severe downdraft during takeoff initial climb, and an in-flight collision with terrain. Factors associated with the accident were a thunderstorm and a downdraft.NTSB SEA06FA139Accident · 1 fatalField investigationFinal reportPiper PA-31-350 · Easton, WAThe loss of power in both engines for undetermined reasons while in cruise flight, leading to an attempted forced landing. Factors include unfavorable winds at the site of the forced landing, and trees off the approach end of the grass runway the pilot was…NTSB NYC06LA178Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164B · Frederick, MDA failure of the masterod, due to a hydraulic lock on a previous flight, which resulted in a total loss of engine power.NTSB LAX06TA234Accident · No injuriesFinal reportLet Super Blanik L-23 · Los Alamitos, CAfailure of the winch operator to maintain an adequate winch tow speed, resulting in a stall and hard landing.NTSB LAX06LA235Accident · Minor injuriesLimited investigationFinal reportAlfred Long-EZ · Hesperia, CAThe pilot's failure to maintain the proper glide path on final approach as a result of the visual illusions created by a narrow, upsloping runway.NTSB LAX06LA229Accident · No injuriesLimited investigationFinal reportVelocity 173/RG-XL · Modesto, CAthe pilot's misjudged flare and improper recovery from a bounced landing, which resulted in a hard landing and landing gear collapse. A contributing factor was the pilot/builder's inadequate adjustment of the landing gear cable tension.NTSB LAX06LA228Accident · No injuriesLimited investigationFinal reportPalmer Seawind 3000 · Havasu Lake, CAan electrical fire due to improper wiring of the electrical system by other maintenance personnel.