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.

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.Jul 8, 1995 · N7608H · Substantial damageNTSB FTW95LA280Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly 7 · Littleton, COThe failure of the pilot to maintain control of the Balloon during landing.Jul 8, 1995 · N2232H · No damageNTSB 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.Jul 8, 1995 · N57669 · Substantial damageNTSB CHI95FA212Accident · 1 fatalField investigationFinal reportTaylorcraft BC-65 · Plato Center, ILthe pilot not maintaining an adequate fuel supply, and not maintaining airspeed.Jul 8, 1995 · N1027K · Substantial damageNTSB 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.Jul 8, 1995 · N150AE · DestroyedNTSB 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.Jul 7, 1995 · N95633 · Substantial damageNTSB 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.Jul 7, 1995 · N9324B · DestroyedNTSB FTW95LA286Accident · No injuriesLimited investigationFinal reportCessna 152 · Bridgeport, TXThe failure of the pilot to maintain airspeed resulting in an inadvertent stall.Jul 7, 1995 · N6306H · Substantial damageNTSB FTW95LA284Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502 · Elaine, ARThe pilot did not maintain a positive rate of climb.Jul 7, 1995 · N91282 · Substantial damageNTSB 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.Jul 7, 1995 · N8972Q · Substantial damageNTSB 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.Jul 7, 1995 · N632FL · Substantial damageNTSB 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.Jul 7, 1995 · N412LF · DestroyedNTSB 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.Jul 7, 1995 · N257C · Substantial damageNTSB 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.Jul 7, 1995 · N6281J · DestroyedNTSB SEA95LA143Accident · No injuriesLimited investigationFinal reportAero Commander S2R · Odessa, WALoss of engine power due to a cracked cylinder.Jul 6, 1995 · N3662X · Substantial damageNTSB 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.Jul 6, 1995 · N7487Y · Substantial damageNTSB NYC95LA142Accident · No injuriesLimited investigationFinal reportBell 206-BIII · New York, NYThe pilot' inadequate preflight inspection. A factor was the pilot's diverted attention.Jul 6, 1995 · N206GS · Substantial damageNTSB 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.Jul 6, 1995 · N2175L · Substantial damageNTSB 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.Jul 6, 1995 · N6941V · DestroyedNTSB LAX95LA253Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Maricopa, AZan undetermined internal failure of the carburetor.Jul 6, 1995 · N9188T · Substantial damageNTSB 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.Jul 6, 1995 · N5654X · Substantial damageNTSB 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.Jul 6, 1995 · N60078 · Substantial damageNTSB ANC95LA097Accident · No injuriesLimited investigationFinal reportCessna 180 · Naknek, AKThe pilot's selection of unsuitable terrain for taxi.Jul 6, 1995 · N2975C · Substantial damageNTSB 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.Jul 6, 1995 · N8324 · Substantial damageNTSB SEA95LA140Accident · No injuriesLimited investigationFinal reportCessna 182R · Copalis Beach, WAThe pilot's selection of an unsuitable landing area.Jul 5, 1995 · N4836E · Substantial damageNTSB 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.Jul 5, 1995 · N8676X · Substantial damageNTSB 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.Jul 5, 1995 · N112AE · Minor damageNTSB 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.Jul 5, 1995 · N11064 · Substantial damageNTSB 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.Jul 5, 1995 · N9144T · Substantial damageNTSB 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.Jul 5, 1995 · N70216 · Substantial damageNTSB 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.Jul 5, 1995 · N15743 · DestroyedNTSB 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.Jul 5, 1995 · N3774Z · Substantial damageNTSB 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.Jul 5, 1995 · N6946K · Substantial damageNTSB SEA95LA139Accident · Serious injuriesLimited investigationFinal reportHughes 369HS · Orting, WAThe pilot's failure to see and avoid the cable.Jul 4, 1995 · N9196F · Substantial damageNTSB 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.Jul 4, 1995 · N718RS · DestroyedNTSB NYC95LA140Accident · No injuriesLimited investigationFinal reportNicolas Beasely NB-8 · Bayport, NYThe loss of power for undetermined reasons.Jul 4, 1995 · N583Y · Substantial damageNTSB MIA95LA170Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Winstonville, MSPoor preflight planning/preparation and clearance not maintained by the pilot in command.Jul 4, 1995 · N6323Y · Substantial damageNTSB 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.Jul 4, 1995 · N8634 · DestroyedNTSB 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.Jul 4, 1995 · N712RC · Minor damageNTSB 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.Jul 4, 1995 · N757VK · Substantial damageNTSB 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.Jul 4, 1995 · N5402V · No damageNTSB ATL95LA127Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Fairview, TNThe pilot's failure to maintain flying speed during climbout. A factor was the wind gust.Jul 4, 1995 · N6051G · Substantial damageNTSB ANC95LA094Accident · No injuriesLimited investigationFinal reportBeech 36 · Chitina, AKAn inadvertent stall while on approach. The pilot-in-command's inadequate remedial action was a factor.Jul 4, 1995 · N8067U · Substantial damageNTSB 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.Jul 3, 1995 · N1887G · Substantial damageNTSB 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.Jul 3, 1995 · N88631 · Substantial damageNTSB NYC95LA141Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Smoketown, PAfailure of the pilot to follow the recommended starting procedures.Jul 3, 1995 · N82773 · Substantial damageNTSB MIA95LA173Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502 · Belzoni, MSInadequate compensation for wind conditions by the pilot. The gusty crosswind was a factor.Jul 3, 1995 · N91955 · Substantial damageNTSB 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…Jul 3, 1995 · N1348Z · Substantial damageNTSB 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.Jul 3, 1995 · N6317U · Minor damageNTSB FTW95LA274Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Colorado Spgs, COAn inadvertent windshear encounter. A factor was the high density altitude.Jul 3, 1995 · N55365 · Substantial damage