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 NYC96LA086Accident · Serious injuriesLimited investigationFinal reportHughes 269A · Linden, NJimproper flare by the pilot, and his failure to take proper corrective action after the helicopter touched down hard and entered ground resonance.NTSB LAX96LA174Accident · No injuriesLimited investigationFinal reportHelio H-295 · Grand Canyon, AZthe partial failure of the landing gear brake system resulting from loss of the clips retaining the right-hand brake disk. The resulting loss of braking authority impaired the pilot's ability to maintain directional control in a left quartering tailwind and…NTSB IAD96LA065Accident · No injuriesLimited investigationFinal reportCessna 150H · Clinton, MDa loss of engine power for undetermined reasons.NTSB IAD96LA064Accident · Serious injuriesLimited investigationFinal reportPiper PA-22-135 · Dover, DEthe overhaul maintenance personnel's improper major overhaul procedure (improper torque on the engine block center through bolts), which resulted in an in flight loss of engine power. A related factor was the lack of suitable terrain available for a forced…NTSB FTW96LA175Accident · No injuriesLimited investigationFinal reportRobinson R22 Beta · Franklin, LAThe pilot's poor judgment in attempting to refuel the helicopter with the engine (and rotors) operating. Factors relating to the accident were: the gusty wind condition, and close proximity of the vehicle that was allowed to be driven under the turning rotors.NTSB CHI96FA139Accident · 1 fatalField investigationFinal reportCessna 150F · Mackinac Island, MIthe student pilot iniating VFR flight into instrument meteorological conditions which led to a loss of aircraft control. A factor was the fog.NTSB SEA96LA083Accident · No injuriesLimited investigationFinal reportCessna 172 · Cheyenne, WYthe pilot's improper flare during the landing and improper recovery from the subsequent bounced landing. A factor relating to the accident was: the pilot's failure to maintain the proper approach path during the approach for landing.NTSB SEA96LA081Accident · Minor injuriesLimited investigationFinal reportForth Acro 2 · Rock Springs, WYthe pilot's improper decision to attempt a takeoff from a road with gusting crosswinds, and his failure to adequately compensate for wind conditions during the takeoff. Factors contributing to the accident were gusts, crosswinds, and windshear.NTSB MIA96LA122Accident · Minor injuriesLimited investigationFinal reportGrumman G-164A · Edison, GAFailure of the mounting studs for the No. 4 cylinder, which resulted in separation of the cylinder and loss of engine power. The lack of suitable terrain for a forced landing was a related factor.NTSB MIA96LA121Accident · No injuriesLimited investigationFinal reportCessna 310D · Palmetto, GAFailure of the pilot-in-command to maintain the proper descent rate resulting in a hard landing and collapse of the right main landing gear.NTSB FTW96LA177Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502B · Pond Creek, OKThe pilot's improper planning/decision and failure to obtain/maintain sufficient airspeed to climb after takeoff, which resulted in a stall/mush and subsequent collision with terrain. Factors relating to the accident were: failure of the pilot to follow short…NTSB FTW96LA174Accident · No injuriesLimited investigationFinal reportSchweizer 269C · Silver, TXthe pilot's failure to maintain adequate rotor RPM.NTSB CHI96LA134Accident · No injuriesLimited investigationFinal reportCessna 172 · David City, NEthe instructor pilot failed to maintain control of the aircraft during a soft field takeoff. Factors were the gusting winds and the soft field.NTSB CHI96FA135Accident · 2 fatalField investigationFinal reportPiper J-3 · Raymond, NEfailure of the pilot to ensure that the fuel selector was properly positioned to the full 'on' position before takeoff, which resulted in a loss of engine power due to fuel starvation during the initial climb after takeoff; and the pilot's failure to maintain…NTSB LAX96LA173Accident · No injuriesLimited investigationFinal reportCessna 150K · Mojave, CAthe pilot's failure to clear the engine during an idle power descent, as required by the engine manual.NTSB FTW96LA172Accident · No injuriesLimited investigationFinal reportCessna 305A · Erie, COentanglement of the tow banner during banner pickup, and subsequent failure or inability to jettison the banner. A factor relating to the accident was: high gusty wind condition.NTSB ANC96LA052Accident · No injuriesLimited investigationFinal reportCessna 170B · Chicken, AKThe first pilot's failure to maintain clearance with a tree. Factors in the accident were the first pilot's inadequate preflight planning and preparation and soft snow conditions.NTSB ANC96LA051Accident · Serious injuriesLimited investigationFinal reportCessna 206G · Whittier, AKThe pilot's continued VFR flight into instrument meteorological conditions. Factors in the accident were low ceilings and whiteout conditions.NTSB ANC96LA049Accident · Serious injuriesLimited investigationFinal reportCessna 207 · Kotzebue, AKfailure of the pilot to maintain sufficient altitude/clearance above terrain, after becoming spatially disoriented, while maneuvering after takeoff. Factors relating to the accident were: fog, snow, partial obscuration, 'flat' conditions of light, and the…NTSB NYC96FA085Accident · 1 fatalField investigationFinal reportPiper PA-28-181 · Granville, OHthe pilot's intentional flight into known icing conditions and his overconfidence in his ability, which led to a partial loss of engine power as a result of induction system ice. Also causal was ATC's excessive vectoring of the airplane in icing conditions,…NTSB MIA96LA120Accident · No injuriesLimited investigationFinal reportMooney M20C · St Augustine, FLinadequate visual lookout by the pilots of both airplanes, which resulted in their failure to see-and-avoid each other's airplane. A factor relating to the accident was: the lack of traffic pattern position reports from the Christian Eagle, due to the…NTSB MIA96LA119Accident · Minor injuriesLimited investigationFinal reportAeronca 7BCM · Portland, TNDelay by the pilot-in-command to perform a go-around after the airplane bounced three times during the landing attempt. Contributing to the accident was the failure of the pilot to obtain a preflight weather briefing and his poor in-flight planning decision…NTSB MIA96FA118Accident · 1 fatalField investigationFinal reportHawker Siddeley FB-60 · Lakeland, FLThe pilot's improper use of brakes and ailerons, during the landing rollout with a right crosswind, which resulted in a loss of directional control and subsequent nose over. Factors relating to the accident were: the crosswind and the pilot's lack of…NTSB LAX96LA172Accident · No injuriesLimited investigationFinal reportBell 206B III · San Diego, CAthe student's failure to maintain adequate main rotor rpm and airspeed during a practice autorotation, and the instructor's inadequate supervision of the flight.NTSB LAX96LA171Accident · Minor injuriesLimited investigationFinal reportBryan Glasair 3SH-3R · Sedona, AZthe pilot's misjudged landing flare which resulted in a hard, bounced landing, and his improper recovery technique. A contributing factor was the pilot's failure to attain a proper initial touchdown point on the runway surface during dusk light conditions.NTSB IAD96LA063Accident · 2 fatalLimited investigationFinal reportGlasair GL20 · Rocky Mount, VAthe pilot's continued flight into adverse weather conditions which led to airframe ice and a loss of control. Related factors were: the failure of the FSS briefer to advise the pilot of a valid AIRMET regarding icing conditions, the icing conditions, and…NTSB MIA96FA116Accident · 1 fatalField investigationFinal reportPiper PA-28-151 · Kissimmee, FLthe pilot's improper planning/decision, which resulted in fuel starvation and a forced landing in a residential area. A factor relating to the accident was: the inaccuracy of the expected fuel consumption.NTSB LAX96FA169Accident · 2 fatalField investigationFinal reportCameron A-210 · Cave Creek, AZthe pilot's failure to follow the flight manual procedure by not turning off the burner's pilot shutoff valves. Factors relating to the accident were: the installation of improper (unapproved wooden) upright rods by company maintenance personnel, subsequent…NTSB ANC96LA050Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Palmer, AKimproper planning/decision by the pilot, and his selection of unsuitable terrain on which to land a ski equipped airplane.NTSB LAX96LA170Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Santa Paula, CAfuel starvation due to the pilot's failure to monitor fuel tank quantities and to assure that the fuel tank selector was positioned to a tank containing adequate fuel.NTSB LAX96LA168Accident · No injuriesLimited investigationFinal reportHughes 369D · Yerington, NVthe partial loss of engine power and the pilot's misjudged flare during an autorotation landing in soft dirt with excessive forward speed. The power loss resulted from flight operations in an environment which debris contaminated the engine's nozzle port and…NTSB LAX96LA167Accident · No injuriesLimited investigationFinal reportMaule M-5-235C · Lake Havasu Cty, AZthe pilot-owner's inadequate engine maintenance which resulted in a progressive ignition failure. Factors which contributed to the accident were the dark nighttime light condition and the presence of hidden obstructions in the forced landing area.NTSB IAD96LA062Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Saluda, VAwas the pilot's failure to follow the manufacturer's recommended approach reference speed (VREF) during the approach.NTSB IAD96FA061Accident · 1 fatalField investigationFinal reportCessna P206C · Hartwood, VAthe inadvertent/premature deployment of the first skydiver's parachute, which resulted in contact with the airplane's horizontal stabilizer by the first skydiver and his parachute, loss of integrity of the empennage to the aft fuselage, loss of aircraft…NTSB FTW96LA171Accident · 1 fatalLimited investigationFinal reportCessna U206G · Venice, LAthe pilot's inadvertent flight into instrument meteorological conditions. A factor was the fog.NTSB FTW96LA170Accident · No injuriesLimited investigationFinal reportExplorer Post 51 AA Cubette · Dell City, TXthe pilot's failure to maintain obstacle clearance during a go-around. Factors were the gusty wind and the pilot's inadequate compensation for the wind.NTSB FTW96LA169Accident · No injuriesLimited investigationFinal reportBeech E35 · Albuquerque, NMa partial loss of engine power for undetermined reasons, and the pilot's failure to abort the takeoff.NTSB ATL96LA080Accident · Minor injuriesLimited investigationFinal reportCessna 150H · Enterprise, ALfailure of the pilot to maintain directional control of the airplane during a go-around. A factor relating to the accident was: improper flare by the pilot during the landing.NTSB ANC96LA047Accident · Serious injuriesLimited investigationFinal reportCessna 150J · Wasilla, AKA loss of engine power for an undetermined reason.NTSB SEA96LA086Accident · No injuriesLimited investigationFinal reportCessna 150F · Plains, MTthe pilot's excessive use of brakes during the landing rollout.NTSB SEA96LA080Accident · No injuriesLimited investigationFinal reportCessna 150 · Spiden Island, WAthe pilot's selection of an unsuitable airstrip for the landing and subsequent takeoff, and his delay in aborting the takeoff, which resulted in an overrun and collision with an embankment and trees. Factors relating to the accident were: the short, wet,…NTSB CHI96LA132Accident · No injuriesLimited investigationFinal reportSiai-Marchetti S.205/22R · Anoka, MNA loose exhaust system that had become disconnected and blocked, which resulted in partial loss of engine power.NTSB CHI96LA131Accident · No injuriesLimited investigationFinal reportBeech A23A · Saginaw, MIthe student pilot's improper flare and improper recovery from a bounced landing.NTSB ANC96LA055Accident · No injuriesLimited investigationFinal reportPiper PA-11 · Paxson, AKthe student pilot's selection of an unsuitable off airport landing site. Factors associated with the accident were the soft and snow covered terrain.NTSB MIA96IA114Incident · No injuriesIncident investigationFinal reportMitsubishi MU-2G-30 · Columbia, SCfailure of the nose landing gear bearing due to improper assembly and staking (inadequate quality control) by the manufacturer; which prevented the nose gear from retracting and the main gear from extending, and resulted in a subsequent landing on the nose…NTSB MIA96FA115Accident · 3 fatalField investigationFinal reportPiper PA-24-250 · Lakeland, FLthe pilot's failure to maintain airspeed (Vs) while turning on approach from base to final resulting in an inadvertent stall.NTSB LAX96LA166Accident · No injuriesLimited investigationFinal reportRockwell 112TCA · Independence, CAthe pilot's inadequate compensation for the wind conditions. The wind was a factor.NTSB IAD96LA060Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Akron, OHa loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for a forced landing.NTSB CHI96LA130Accident · 3 fatalLimited investigationFinal reportCessna 177B · Perry, MOthe pilot's impairment of judgment and performance due to alcohol, and his failure to maintain altitude/clearance from the power transmission wires. Darkness, restricting the pilot's ability to see-and-avoid the transmission line, was a related factor.NTSB SEA96MA079Accident · 3 fatalClass 1 · MajorFinal reportCessna 177B · Cheyenne, WYthe pilot-in-command's improper decision to take off into deteriorating weather conditions (including turbulence, gusty winds, and an advancing thunderstorm and associated precipitation) when the airplane was overweight and when the density altitude was…