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 LAX06LA048Accident · No injuriesLimited investigationFinal reportCessna 182A · San Diego, CAThe failure of the camshaft due to fatigue of one of the gear teeth, which resulted in a loss of engine power. Factors were the fence and the fence post.NTSB CHI06FA037Accident · 3 fatalField investigationFinal reportPiper PA-28-140 · Atlanta, NEThe non-instrument rated private pilot not maintaining clearance from the marked tower and his continued flight into adverse weather during cruise flight. Factors were the marked tower and the low ceilings present at the accident.NTSB ATL06LA019Accident · 1 fatalLimited investigationFinal reportPiper PA-28-140 · Blairsville, GAThe non-instrument rated pilot's continued flight into known adverse weather and his failure to maintain clearance in mountainous terrain, resulting in an in-flight collision with trees and the ground. A factor in the accident was the pilot's lack of an…NTSB NYC06LA038Accident · Serious injuriesLimited investigationFinal reportPiper PA-24-180 · Lincoln Park, NJThe improper installation of the helicoil by the non-certificated mechanic, and the inadequate inspection of the installation by the certificated mechanic.NTSB LAX06CA046Accident · No injuriesData collectionFinal reportCameron Balloons N-180 · Rancho Santa Fe, CAthe pilot's inadvertent deactivation of the number 2 burner, which resulted in an increased rate of descent and a collision with a tree short of the intended landing zone.NTSB SEA06CA020Accident · No injuriesData collectionFinal reportCessna 195A · Heber City, UTThe failure of the right brake, which resulted in a loss of directional control during the landing roll and a nose down.NTSB LAX06CA045Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Panamint Spring, CAthe pilot's improper in-flight selection of unsuitable terrain for landing.NTSB NYC06IA036Incident · No injuriesIncident investigationFinal reportMooney M20F · Cadiz, KYFuel starvation, which resulted in a loss of engine power.NTSB LAX06CA052Accident · No injuriesData collectionFinal reportBeech C23 · Holbrook, AZThe student pilot's abrupt flare and failure to maintain airspeed, which resulted in a stall. The flight instructor's inadequate supervision of the flight was also causal.NTSB NYC06CA037Accident · No injuriesData collectionFinal reportGrumman AA5A · Maceo, KYThe pilot's misjudged distance/speed, and his failure to properly seat the airplane's recently installed brakes. A factor was the quartering tailwind.NTSB MIA06FA024Accident · 2 fatalField investigationFinal reportPiper PA-32-300 · Mims, FLThe loss of engine power due to improper installation of the #2 cylinder by maintenance personnel, which resulted in the separation of the cylinder as a result of fatigue cracking of the cylinder to crankcase fasteners. A contributing factor was the lack of…NTSB DFW06CA035Accident · No injuriesData collectionFinal reportCessna P206 · New Braunfels, TXThe pilot's improper compensation for the existing wind conditions resulting in a loss of control. A contributing factor was the gusty crosswind.NTSB DFW06CA033Accident · No injuriesData collectionFinal reportPiper PA-23-250 · Bixby, OKThe loss of engine power due to water contamination and corrosion in both gascolators due to improper maintenance. A factor was the lack of suitable terrain for the forced landing.NTSB DEN06IA019Incident · No injuriesIncident investigationFinal reportBeech 1900D · Telluride, COThe tug driver's failure to maintain adequate clearance from the airplane resulting in the baggage cart striking the airplane's stabilon. A factor contributing to the incident was the tug driver's failure to consider the extra height of the cart in relation…NTSB CHI06CA040Accident · Minor injuriesData collectionFinal reportPiper PA-28-180 · Marshall, MOAn in-flight loss of engine power in descent due to fuel exhaustion, and the pilot's inaccurate preflight planning. Contributing to the accident was the unsuitable terrain the pilot encountered and the night conditions.NTSB SEA06LA021Accident · No injuriesLimited investigationFinal reportCessna 180 · Lopez, WAThe airline transport pilot, who was receiving recurrent training, failed to maintain aircraft control, which was followed by an inadvertent ground loop. A contributing factor was the inadequate supervision by the flight instructor.NTSB NYC06FA034Accident · 1 fatalField investigationFinal reportPiper PA-23-250 · Burlington, VTThe pilot's failure to follow the published instrument flight procedure, which resulted in an in-flight collision with terrain. Factors in the accident were the local air traffic controller's inadequate monitoring of the MSAW system, and his delayed…NTSB SEA06IA019Incident · No injuriesIncident investigationFinal reportGulfstream Aerospace G-5 · Hillsboro, ORThe failure of the right main landing gear (MLG) door uplock linkage actuator due to corrosion, which resulted in jamming of the right MLG during the initial takeoff climb.NTSB MIA06WA023Accident · 6 fatalForeign investigationBell B-206L · Cundinamarca, ColombiaNTSB MIA06FA022Accident · 1 fatalField investigationFinal reportAerospatiale AS350B · Homestead, FLThe failure of both pilot's to maintain visual lookout resulting in the mid-air collision. A factor in the accident was the failure of the AS-350B pilot to follow approach procedures suggested in the Speedway Heliport Operations Manual. Findings in the…NTSB LAX06LA044Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-250 · Tucson, AZthe separation of the mixture cable at the carburetor control arm, which resulted in a loss of power, and maintenance personnel's inadequate inspection of the airplane during the last annual inspection.NTSB DFW06CA032Accident · No injuriesData collectionFinal reportPiper PA-34-200 · Anahuac, TXThe student pilot's loss of directional control during the landing. A contributing factor was the flight instructor' delayed remedial action.NTSB DEN06FA018Accident · 1 fatalField investigationFinal reportAmerican Champion 8KCAB · Calhan, COthe pilot's failure to maintain aircraft control. Factors contributing to the accident were the low altitude, and the resultant stall/spin.NTSB NYC06LA033Accident · No injuriesLimited investigationFinal reportBoeing 737-800 · State College, PAThe pilot's improper touchdown and recovery from a bounced landing. Factors to the accident were the operator's failure to provide sufficient information on the use of autothrottles and bounced landing recovery techniques, along with the Federal Aviation…NTSB CHI06LA034Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Batavia, OHThe loss of engine power due to fuel starvation and improper fuel management by the pilot while on approach. Contributing factors were the low altitude and unsuitable terrain encountered during an emergency landing.NTSB ANC06CA010Accident · No injuriesData collectionFinal reportCessna 180H · Anchorage, AKThe pilot's failure to maintain directional control during the takeoff roll, which resulted in the airplane encountering a snow berm, and nosing over. A factor associated with the accident was the snow berm.NTSB NYC06RA032Accident · 8 fatalForeign investigationCessna 208B · Moscow, RussiaNTSB LAX06LA041Accident · 2 fatalLimited investigationFinal reportTingle Special · Tucson, AZThe pilot's excessive use of power during takeoff, which resulted in an inadvertent torque roll shortly after lift off. Also causal was the pilot's failure to abort the takeoff when directional control could not be maintained during the takeoff roll.NTSB LAX06FA043Accident · 4 fatalField investigationFinal reportCessna T210N · Dana Point, CAThe pilot's inability to maintain aircraft control, which resulted in a loss of airspeed and a stall/spin. The inability of the pilot to maintain control of the airplane was likely due to an incapacitating cardiac event.NTSB LAX06CA042Accident · Minor injuriesData collectionFinal reportCessna A185E · Show Low, AZthe pilot's inadequate compensation for crosswind conditions and failure to maintain directional control, which resulted in a ground loop.NTSB MIA06CA021Accident · No injuriesData collectionFinal reportCessna 172R · Kissimmee, FLThe pilot's improper flare and remedial action during landing resulting in an in-flight loss of control and subsequent collision with terrain. A related factor was the crosswind.NTSB LAX06CA040Accident · No injuriesData collectionFinal reportCessna P210R · Palo Alto, CAthe pilot's misjudged altitude and distance, which resulted in an overrun, and his failure to execute a timely go-around during the approach.NTSB DFW06WA036Accident · 3 fatalForeign investigationBritten-Norman BN2A-21 · Cayo Province, BelizeNTSB DEN06GA017Accident · 1 fatalFinal reportCessna 182R · Alpine, WYthe pilot's intentional low level flight/maneuver. A contributing factor was his exercising poor judgment.NTSB CHI06TA033Accident · No injuriesFinal reportSchweizer 269C · Manhattan, KSThe binding of the main rotor blade's tachometer cable during cruise flight resulting in an observed split tachometer indication/aural alarm and perceived mechanical emergency and the unsuitable terrain the pilot encountered during the emergency landing. A…NTSB ATL06CA017Accident · No injuriesData collectionFinal reportCessna 120 · Woodstock, GAThe pilot's excessive braking resulted in a nose over during landing roll.NTSB LAX06CA038Accident · No injuriesData collectionFinal reportPiper PA-28RT-201 · Bakersfield, CAthe pilot's failure to maintain adequate airspeed, which resulted in an accelerated stall and hard landing.NTSB SEA06CA017Accident · No injuriesData collectionFinal reportCessna T210M · Salt Lake City, UTA loss of engine power due to fuel starvation as a result of the pilot's improper in-flight decision not to use the before landing checklist. A factor which contributed to the accident was the improper position of the mixture control.NTSB MIA06LA019Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-180 · Heathrow, FLA partial loss of engine power due to undetermined reasons resulting in a forced landing in a residential area.NTSB LAX06CA037Accident · Serious injuriesData collectionFinal reportHopkins Rutan VariViggen · Aguila, AZthe pilot's failure to maintain an adequate airspeed during landing approach, which resulted in an inadvertent stall. A contributing factor was the pilot's lack of experience in the accident airplane.NTSB DEN06LA014Accident · No injuriesLimited investigationFinal reportCessna 172L · Rock Springs, WYthe loss of engine power for reasons undetermined. Contributing to the accident was the dark night and lack of suitable terrain for a forced landing.NTSB CHI06FA032Accident · 1 fatalField investigationFinal reportAero Commander 500B · Gaylord, MIThe clearance not maintained with terrain during a nonprecision approach. Contributing factors were the ceiling, visibility, night conditions, and trees.NTSB ATL06CA016Accident · Minor injuriesData collectionFinal reportCessna 177 · New Bern, NCThe pilot's failure to activate the carburetor heat during approach resulting in a total loss of engine power due to carburetor ice.NTSB NYC06CA030Accident · Minor injuriesData collectionFinal reportCessna 208 · Southampton, NYThe flight instructor's improper flare and his inadequate remedial action, which resulted in a hard landing.NTSB LAX06LA036Accident · Serious injuriesLimited investigationFinal reportRyan Aeronautical ST3KR · Lincoln, CAThe pilot's failure to maintain airspeed, which resulted in an inadvertent stall while maneuvering.NTSB CHI06LA036Accident · No injuriesLimited investigationFinal reportCessna T310R · Fergus Falls, MNThe presence of wing ice during landing. Contributing factors were the icing conditions and flight into known adverse weather by the pilot.NTSB MIA06WA018Accident · 6 fatalForeign investigationCessna U206E · Ituango, ColombiaNTSB ATL06CA015Accident · Minor injuriesData collectionFinal reportPiper PA-32-260 · Bryson City, NCThe loss of engine power due to carburetor icing, and the pilot's failure to use carburetor heat.NTSB LAX06LA034Accident · No injuriesLimited investigationFinal reportBeech H35 · Kingman, AZa touchdown with the gear partially extended. A factor in the accident was an inoperative landing gear warning horn.NTSB LAX06LA032Accident · No injuriesLimited investigationFinal reportCessna 172R · Ramona, CAthe student pilot's failure to maintain directional control during the landing.