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 NYC95LA148Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Meriden, CTThe pilot's failure to adequately compensate for wind conditions. Contributing factors were wind gusts, crosswinds, and the pilot's lack of experience in type.NTSB FTW95LA280Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly 7 · Littleton, COThe failure of the pilot to maintain control of the Balloon during landing.NTSB FTW95LA279Accident · No injuriesLimited investigationFinal reportBellanca 8GCBC · Wellington, COFatigue failure of the left main landing gear (spring strut), due to the improper maintenance (grinding) by unknown maintenance personnel.NTSB CHI95FA212Accident · 1 fatalField investigationFinal reportTaylorcraft BC-65 · Plato Center, ILthe pilot not maintaining an adequate fuel supply, and not maintaining airspeed.NTSB ATL95LA131Accident · Serious injuriesLimited investigationFinal reportPZL Koliber -150A · Pickens, SCthe inadequate design and operation of the induction airbox. A factor in the accident was the carburetor icing weather conditions.NTSB MIA95LA177Accident · No injuriesLimited investigationFinal reportCessna 152 · Boca Raton, FLThe failure of the pilot to maintain directional control during a go-around from a bounced landing.NTSB MIA95FA174Accident · 2 fatalField investigationFinal reportCessna 172RG · Ft. Lauderdale, FLThe failure of the pilot to maintain airspeed after a momentary loss of engine power during takeoff, resulting in an inadvertent stall/spin. The reason for power loss could not be determined.NTSB FTW95LA286Accident · No injuriesLimited investigationFinal reportCessna 152 · Bridgeport, TXThe failure of the pilot to maintain airspeed resulting in an inadvertent stall.NTSB FTW95LA284Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502 · Elaine, ARThe pilot did not maintain a positive rate of climb.NTSB FTW95LA283Accident · No injuriesLimited investigationFinal reportAero Commander S2R · Widener, ARLoss of engine power for an undetermined reason. The proximity of power lines (obstruction) was a related factor.NTSB CHI95LA213Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Culver, INThe student pilot's failure to maintain directional control of the airplane, while performing a go-around. A factor relating to the accident was: the proximity of trees beside the runway.NTSB CHI95LA211Accident · 1 fatalLimited investigationFinal reportFirst Strike Bobcat · Burlington, IAfatigue failure of a copper fuel line at the carburetor ferrule fitting, which resulted in fuel starvation. The proximity of trees was a related factor.NTSB ANC95LA099Accident · No injuriesLimited investigationFinal reportStinson 108-2 · Anchorage, AKThe pilot's loss of directional control, during the takeoff roll, which resulted in an inadvertent swerve, and the pilot's excessive application of brake pressure, which resulted in a nose down condition.NTSB ANC95FA101Accident · 6 fatalField investigationFinal reportPiper PA-32R-300 · Haines, AKThe pilot's failure to maintain an adequate altitude above and clearance from the surrounding terrain. A factor related to the accident was the pilot's improper decision to conduct the maneuver in such close proximity to the rising terrain.NTSB SEA95LA143Accident · No injuriesLimited investigationFinal reportAero Commander S2R · Odessa, WALoss of engine power due to a cracked cylinder.NTSB SEA95LA142Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Island Park, IDThe pilot's inadequate compensation for wind conditions. A factor to the accident was wind gusts.NTSB NYC95LA142Accident · No injuriesLimited investigationFinal reportBell 206-BIII · New York, NYThe pilot' inadequate preflight inspection. A factor was the pilot's diverted attention.NTSB MIA95LA176Accident · No injuriesLimited investigationFinal reportKashpureff Nieuport II · Venice, FLThe pilot-in-command's inability to maintain airspeed after encountering a sudden wind shift after lift off resulting in an inadvertent stall, uncontrolled descent, and ground collision.NTSB MIA95FA175Accident · 2 fatalField investigationFinal reportMooney M20F · Cedar Key, FLContinued flight by the pilot into known adverse weather (vip level three thunderstorm). The thunderstorm was a related factor.NTSB LAX95LA253Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Maricopa, AZan undetermined internal failure of the carburetor.NTSB FTW95LA282Accident · No injuriesLimited investigationFinal reportAero Commander S2R · Newport, ARA disconnected throttle push pull rod, due to inadequate maintenance. A factor relating to the accident was: the lack of suitable terrain for the forced landing.NTSB CHI95LA210Accident · No injuriesLimited investigationFinal reportBeech 76 · Wheeling, ILthe dual student's inadequate compensation for the wind conditions, and the CFI's inadequate supervision of the flight. A factor associated with the accident was the gusty crosswind condition.NTSB ANC95LA097Accident · No injuriesLimited investigationFinal reportCessna 180 · Naknek, AKThe pilot's selection of unsuitable terrain for taxi.NTSB ANC95FA095Accident · 1 fatalField investigationFinal reportPiper PA-18 · Nulato, AKThe pilot's failure to maintain adequate airspeed and clearance (altitude) above the water, while maneuvering at low altitude. A factor related to the accident was: the pilot's improper decision to allow a passenger to accompany the flight without a seat belt.NTSB SEA95LA140Accident · No injuriesLimited investigationFinal reportCessna 182R · Copalis Beach, WAThe pilot's selection of an unsuitable landing area.NTSB FTW95LA269Accident · No injuriesLimited investigationFinal reportCessna 180E · Springdale, ARThe pilot's failure to compensate for the crosswind conditions. Factors were the crosswind, and the pilot's improper weather evaluation.NTSB FTW95IA271Incident · No injuriesIncident investigationFinal reportSaab-Scania SF340A · Temple, TXImproper installation of the right main gear outboard wheel, which resulted in separation of the wheel from the axle during takeoff.NTSB FTW95FA270Accident · Serious injuriesField investigationFinal reportChampion 7ECA · Lake Dallas, TXThe pilot's failure to maintain airspeed and the resulting inadvertent stall/spin. A factor was inadequate maintenance resulting in the partial loss of engine power due to the number one cylinder exhaust valve being stuck open.NTSB CHI95LA216Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Chesterfield, MOThe pilot's failure to maintain control of the airplane while landing and his inadequate compensation for wind conditions. A factor in the accident was the gusty crosswind conditions.NTSB ATL95LA129Accident · 1 fatalLimited investigationFinal reportBensen B-8M · Siler City, NCThe pilot's failure to maintain control of the gyrocopter which resulted in an inflight breakup. A factor was the pilot's lack of a rotorcraft or gyrocopter certification.NTSB ATL95FA128Accident · 2 fatalField investigationFinal reportPiper PA-28R-200 · Raleigh, NCThe pilot's failure to follow proper IFR procedures by descending below the decision height. Factors relating to the accident were the weather conditions and the dark night.NTSB ANC95LA098Accident · No injuriesLimited investigationFinal reportPiper PA-18-160 · Palmer, AKThe pilot's failure to maintain directional control, during an off-airport landing on rough/uneven terrain, which resulted in an inadvertent ground swerve. The terrain condition was a related factor.NTSB ANC95LA096Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Homer, AKThe pilot's improper (excessive) use of the brakes after the airplane crested the landing site's crown and started downhill.NTSB SEA95LA139Accident · Serious injuriesLimited investigationFinal reportHughes 369HS · Orting, WAThe pilot's failure to see and avoid the cable.NTSB SEA95FA136Accident · 1 fatalField investigationFinal reportAlon Aircoupe A-2 · Cody, WYThe pilot's failure to maintain clearance from terrain while maneuvering to reverse course. A factor was the downdrafts encountered in the mountainous terrain.NTSB NYC95LA140Accident · No injuriesLimited investigationFinal reportNicolas Beasely NB-8 · Bayport, NYThe loss of power for undetermined reasons.NTSB MIA95LA170Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Winstonville, MSPoor preflight planning/preparation and clearance not maintained by the pilot in command.NTSB LAX95LA240Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Long Beach, CAthe inadvertent entanglement of the banner tow cable with the rudder control system, which resulted in a full and uncorrectable deflection of the rudder, and the pilot's inability to control the aircraft.NTSB LAX95IA246Incident · No injuriesIncident investigationFinal reportBoeing 727-257 · Las Vegas, NVA shear failure of the right main landing gear outer cylinder trunnion due to fatigue and stress corrosion, and the operator's inadequate and improper overhaul procedures.NTSB FTW95LA268Accident · No injuriesLimited investigationFinal reportCessna 152 · Farmington, NMThe student pilot's inadequate compensation for wind conditions during the landing, which resulted in her failure to maintain proper runway alignment. The gusty crosswind was a related factor.NTSB FTW95LA267Accident · Serious injuriesLimited investigationFinal reportThunder and Colt AX7-77 · Santa Fe, NMThe pilot's improper planning for the high wind landing. Factors were the unfavorable winds and the tree stump.NTSB ATL95LA127Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Fairview, TNThe pilot's failure to maintain flying speed during climbout. A factor was the wind gust.NTSB ANC95LA094Accident · No injuriesLimited investigationFinal reportBeech 36 · Chitina, AKAn inadvertent stall while on approach. The pilot-in-command's inadequate remedial action was a factor.NTSB SEA95LA144Accident · Minor injuriesLimited investigationFinal reportChampion 7GCBC · Moses Lake, WAThe pilot's failure to maintain directional control during the landing and go around. The crosswind and gusty wind conditions were factors in the accident.NTSB NYC95LA151Accident · Serious injuriesLimited investigationFinal reportPiper J3C-65 · North Benton, OHFuel starvation for an unknown reason, resulting in a loss of engine power; and failure of the pilot to maintain adequate airspeed, which resulted in an inadvertent stall.NTSB NYC95LA141Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Smoketown, PAfailure of the pilot to follow the recommended starting procedures.NTSB MIA95LA173Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502 · Belzoni, MSInadequate compensation for wind conditions by the pilot. The gusty crosswind was a factor.NTSB LAX95LA238Accident · No injuriesLimited investigationFinal reportHiller UH-12C · Rio Vista, CAThe result of a chafing failure of the left anti-torque control cable while the aircraft was in flight. An inadequate preflight inspection by the pilot-in-command, and an inadequate 100-hour inspection by company maintenance personnel were factors in this…NTSB LAX95LA237Accident · 1 fatalLimited investigationFinal reportAerostar S-77A · Davis, CAthe pilot's misjudgement of the balloon's excessive rate-of-descent in a high wind landing and her inadequate remedial action to correct the condition.NTSB FTW95LA274Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Colorado Spgs, COAn inadvertent windshear encounter. A factor was the high density altitude.