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 DEN00LA131Accident · Minor injuriesLimited investigationFinal reportRotorway Executive 162F · Tooele, UTThe pilot's inadequate weather evaluation, which resulted in a downwind landing, and his failure to maintain aircraft control. A factor was the tailwind.Jul 16, 2000 · N6399L · Substantial damageNTSB CHI00LA209Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Ashland, WIthe blocked lubricating system and unsuitable terrain.Jul 16, 2000 · N24GK · Substantial damageNTSB CHI00LA204Accident · Minor injuriesLimited investigationFinal reportBell 47G-3B-1 · Holstein, NEthe settling with power encountered by the pilot. A factor was the sudden windshift.Jul 16, 2000 · N83701 · Substantial damageNTSB CHI00LA203Accident · No injuriesLimited investigationFinal reportWeatherly 201B · Streator, ILthe pilot's preflight planning was inadequate which resulted in taking off in the wrong direction on the runway. Factors associated with the accident were the tailwind condition and the crop that the airplane contacted.Jul 16, 2000 · N1261W · Substantial damageNTSB CHI00LA201Accident · Minor injuriesLimited investigationFinal reportWitlock CIRCA-NIEUPORT 12 · Peotone, ILthe carburetor icing conditions and the fact that the aircraft was not equipped with carburetor heat protection. A factor to the accident was the crops.Jul 16, 2000 · N317LS · Substantial damageNTSB SEA00LA134Accident · No injuriesLimited investigationFinal reportCessna 182 · Snohomish, WAThe right main landing gear failed for undetermined reasons.Jul 15, 2000 · N6473A · Substantial damageNTSB LAX00LA289Accident · No injuriesLimited investigationFinal reportCessna 172K · Palo Alto, CAThe pilot of the other airplane's (Cessna) inadequate visual lookout and misjudged distance to the standing Beech.Jul 15, 2000 · N79004 · 2 aircraft · Substantial damageNTSB LAX00LA267Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-160 · Lancaster, CAThe pilot's inadequate compensation for gusty winds conditions that resulted in the collision with a power line during final approach.Jul 15, 2000 · N8768D · Substantial damageNTSB LAX00LA266Accident · No injuriesLimited investigationFinal reportCessna 152 · San Jose, CAThe pilot's in-flight decision to continue the takeoff and his subsequent delayed decision to abort the takeoff after he noted that the airplane was unable to climb out of ground effect.Jul 15, 2000 · N67603 · Substantial damageNTSB LAX00LA265Accident · Serious injuriesLimited investigationFinal reportCessna TR182 · Las Vegas, NVThe pilot's failure to refuel the airplane and his improper fuel consumption calculations.Jul 15, 2000 · N738XP · Substantial damageNTSB FTW00LA211Accident · Minor injuriesLimited investigationFinal reportBeech D35 · Decatur, ARThe inadvertent stall while maneuvering to avoid obstructions during a forced landing. A factor was the pilot's failure to extend the landing gear, which resulted in a partial loss of engine power due to the propeller blades striking the runway.Jul 15, 2000 · N3424B · Substantial damageNTSB FTW00LA210Accident · 1 fatalLimited investigationFinal reportGrumman-Schweizer G-164B · Ville Platte, LAThe loss of control for an undetermined reason.Jul 15, 2000 · N428KG · DestroyedNTSB DEN00LA130Accident · No injuriesLimited investigationFinal reportCessna 150L · Reserve, NMSeizure of the starter clutch assembly needle bearing, which caused the engine to develop less than full rated power and the airplane to achieve less than expected climb performance. Factors were noncompliance of a service bulletin, unsuitable terrain on…Jul 15, 2000 · N18124 · Substantial damageNTSB CHI00LA198Accident · No injuriesLimited investigationFinal reportCessna T188C · Rock Dell, MNthe failure of the pilot to maintain clearance with the terrain.Jul 15, 2000 · N9957J · Substantial damageNTSB CHI00FA200Accident · 1 fatalField investigationFinal reportBeech 35 · Columbus, NEthe failure of the pilot to maintain clearance from the power line. Factors were the sunglare and the wire.Jul 15, 2000 · N947V · DestroyedNTSB ANC00LA090Accident · No injuriesLimited investigationFinal reportMaule ML-5 · Wasilla, AKThe pilot's improper use of the fuel tank selector, resulting in fuel starvation.Jul 15, 2000 · N6194M · Substantial damageNTSB ANC00LA089Accident · Minor injuriesLimited investigationFinal reportAeronca 11BC · Wasilla, AKA loss of engine power due to the pilot's failure to use carburetor heat, and an inadvertent stall. A factor associated with the accident was the existence of carburetor icing conditions.Jul 15, 2000 · N9359E · Substantial damageNTSB MIA00FA217Accident · 2 fatalField investigationFinal reportCessna 150M · Holly Springs, MSThe failure of the pilot to maintain control while maneuvering the aircraft due to impairment as a result of use of illegal drugs, and the subsequent collision with the terrain during an uncontrolled descent.Jul 14, 2000 · N9249U · DestroyedNTSB LAX00LA262Accident · No injuriesLimited investigationFinal reportRobinson R-22 Beta · Lake Piru, CAThe improper use of the cyclic control by the pilot under instruction, and the flight instructor's lack of remedial action.Jul 14, 2000 · N169CW · Substantial damageNTSB FTW00LA213Accident · No injuriesLimited investigationFinal reportErcoupe 415-C · Stephenville, TXThe collision with a bird while in cruise flight.Jul 14, 2000 · N99236 · Substantial damageNTSB FTW00FA208Accident · 2 fatalField investigationFinal reportBellanca 17-30A · Houston, TXthe loss of engine power for an undetermined reason during maneuvering. Contributing factors were the dark night light conditions and the lack of suitable terrain for the forced landing.Jul 14, 2000 · N8263R · DestroyedNTSB CHI00LA196Accident · Serious injuriesLimited investigationFinal reportAerostar S-77A · River Falls, WIthe unfavorable wind condition for landing and control of the balloon during landing not possible by the pilot.Jul 14, 2000 · N5075H · No damageNTSB SEA00FA133Accident · 3 fatalField investigationFinal reportCessna 150E · Ashton, IDThe pilot's failure to maintain clearance from a tree while making a low pass over an outdoor gathering of individuals. Factors include the intentional low pass, a tree located in a shadow generated by the sun's low position at dusk, hilly terrain, and the…Jul 13, 2000 · N6196T · DestroyedNTSB LAX00TA263Accident · No injuriesFinal reportCessna 337G · Battle Mountain, NVFailure of the pilot to extend the landing gear, and his failure to follow the published before landing checklist concerning extension of the landing gear.Jul 13, 2000 · N3273D · Substantial damageNTSB LAX00LA271Accident · No injuriesLimited investigationFinal reportAir Tractor AT-401 · Ripley, CAA loss of engine power due to the separation of a connecting rod from the crankshaft.Jul 13, 2000 · N4508Y · Substantial damageNTSB FTW00LA209Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164B · Kaplan, LAThe loss of engine power for an undetermined reason. A factor was the lack of suitable terrain for the forced landing.Jul 13, 2000 · N8151K · Substantial damageNTSB DEN00LA143Accident · No injuriesLimited investigationFinal reportMooney M20J · Espanola, NMThe lack of suitable terrain for a forced landing. A factor was a complete loss of power due to mechanical failure.Jul 13, 2000 · N201DK · Substantial damageNTSB CHI00LA207Accident · Serious injuriesLimited investigationFinal reportChilian Kitfox 1200 IV · Lowell, INthe incapacitation of the pilot. Factors to the accident were the failure of the pilot to maintain flying speed and the subsequent stall.Jul 13, 2000 · N456RC · Substantial damageNTSB CHI00LA202Accident · No injuriesLimited investigationFinal reportCessna 152 · Park River, NDdirectional control not being maintained by the pilot during landing.Jul 13, 2000 · N69066 · Substantial damageNTSB CHI00LA199Accident · No injuriesLimited investigationFinal reportCessna 140 · St. Francis, MNthe pilot selected to land in a field that was unsuitable for landing. A factor was the soft field.Jul 13, 2000 · N76427 · Substantial damageNTSB CHI00LA195Accident · Serious injuriesLimited investigationFinal reportBoeing Stearman A75N1(PT17) · Windsor, MOfuel exhaustion and the pilot abruptly applying normal brakes during the landing roll. Factors relating to this accident were the precautionary landing, and the pilot's inadequate in-flight planning/ decision.Jul 13, 2000 · N53131 · Substantial damageNTSB CHI00LA194Accident · No injuriesLimited investigationFinal reportPiper PA-22-160 · Olivia, MNthe failure of the pilot to maintain directional control of the aircraft. A factor to the accident was the pocket gopher mound in the wheat field.Jul 13, 2000 · N8136D · Substantial damageNTSB SEA00WA135Accident · No injuriesForeign investigationBell 407 · Golden, CanadaJul 12, 2000 · N409KA · Substantial damageNTSB NYC00LA197Accident · Serious injuriesLimited investigationFinal reportFairchild M-62C · Carthage, NYthe pilot's improper decision to depart with obstacles ahead which exceeded the climb capability of the airplane. Factors were the grass runway, and trees at the departure end of the runway.Jul 12, 2000 · N58741 · Substantial damageNTSB MIA00LA220Accident · No injuriesLimited investigationFinal reportAeronca 65-TC · Harris, NCThe unsuitable terrain encountered by the pilot while descending for a forced landing. Contributing to the accident was the partial loss of engine power due a blocked fuel line resulting in fuel starvation.Jul 12, 2000 · N29416 · Substantial damageNTSB LAX00LA264Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Selma, CAA cracked plastic fuel selector handle that precluded proper engagement of the internal mechanism to fully select a port, and left it in an intermediate position, restricting the fuel supply to the engine, which subsequently lead to a loss of engine power.Jul 12, 2000 · N2466D · Substantial damageNTSB FTW00LA207Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Columbus, TXthe failure of both magnetos of the dual-magneto single-drive unit. A factor contributing to the accident was the lack of suitable terrain for the forced landing.Jul 12, 2000 · N3392E · Substantial damageNTSB FTW00LA205Accident · No injuriesLimited investigationFinal reportPiper PA-23-160 · Rio Grande City, TXthe loss of engine power for undetermined reasons. Contributing factors were the pilot flying the airplane with known deficiencies, and the lack of suitable terrain for the forced landing.Jul 12, 2000 · N4322P · Substantial damageNTSB DCA00WA068Accident · Minor injuriesForeign investigationAirbus A310-304 · Vienna, AustriaJul 12, 2000 · D-AHLB · DestroyedNTSB ANC00LA086Accident · No injuriesLimited investigationFinal reportCessna 207 · Kotlik, AKThe pilot's inadequate flare during landing.Jul 12, 2000 · N1549U · Substantial damageNTSB SEA00LA131Accident · Minor injuriesLimited investigationFinal reportWsk Pzl Mielec M-18 Dromader · Burley, IDImproper airstrip operations by ground personnel, and the pilot's failure to visually detect a vehicle on the airstrip in time to avoid a collision. Factors included a vehicle on the airstrip, tailwind conditions, and high density altitude conditions.Jul 11, 2000 · N2054S · DestroyedNTSB SEA00LA129Accident · Serious injuriesLimited investigationFinal reportKaman K-1200 · Cusick, WAThe termination of power to the main rotor system as a result of the malfunction of the free-wheeling sprag clutch assembly, followed by the torsional overload separation of the engine adapter shaft. Factors include trees in the area where the emergency…Jul 11, 2000 · N311KA · Substantial damageNTSB NYC00LA196Accident · No injuriesLimited investigationFinal reportCessna 337C · Chesapeake, VAThe pilot's failure to follow the published go-around procedure. Factors were the pilot's improper evaluation of the wind conditions, and a tailwind.Jul 11, 2000 · N2574S · Substantial damageNTSB NYC00LA195Accident · No injuriesLimited investigationFinal reportFairchild M-62 · Grafton, OHThe pilot's failure to maintain control of the airplane while taking off.Jul 11, 2000 · N51941 · Substantial damageNTSB NYC00LA191Accident · Serious injuriesLimited investigationFinal reportRobinson R-22B · Harpswell, METhe pilot-in-command's improper in-flight decision to maneuver at a low airspeed with a left-quartering tailwind which resulted in a loss of tailrotor effectiveness.Jul 11, 2000 · N2365S · Substantial damageNTSB LAX00LA261Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Gridley, CAA partial loss of engine power due to the failure of an exhaust valve during an aerial application flight.Jul 11, 2000 · N897X · Substantial damageNTSB FTW00FA201Accident · 1 fatalField investigationFinal reportCessna T210J · Athens, TXthe pilot's inadvertent stall during initial takeoff climb.Jul 11, 2000 · N2244R · DestroyedNTSB ANC00IA088Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas MD-82 · Anchorage, AKAn inoperative traffic alert and collision avoidance system (TCAS).Jul 11, 2000 · N935AS · No damageNTSB SEA00WA130Accident · 4 fatalForeign investigationPiper PA-24-260 · Chilko Lake, CanadaJul 10, 2000 · N8804P · DestroyedNTSB SEA00LA128Accident · No injuriesLimited investigationFinal reportKeith Kinden Rebel · Libby, MTAn improper installation of a rudder control cable Nicopress sleeve by the owner/builder. The rudder control cable disconnection and the slipped cable from the sleeve were factors.Jul 10, 2000 · N6317Y · Substantial damage