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 IAD97LA082Accident · Minor injuriesLimited investigationFinal reportCessna R182 · Poughkeepsie, NYThe pilot's delayed decision to abort the landing.Jun 5, 1997 · N2336C · DestroyedNTSB CHI97LA157Accident · No injuriesLimited investigationFinal reportCessna A188B · La Moure, NDa loss of engine power for undetermined reasons and the pilot's failure to jettison the load. Factors involved were the exceeded weight and balance limits, and the pilot's inadequate preflight planning and preparation.Jun 5, 1997 · N8293G · Substantial damageNTSB ATL97LA084Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Columbus, MSinadequate maintenance/inspection and subsequent corrosion of the air filter, which resulted in pieces of the air filter to block the intake to the carburetor and result in loss of engine power. A factor relating to the accident was: failure of maintenance…Jun 5, 1997 · N7581W · Substantial damageNTSB ATL97LA081Accident · No injuriesLimited investigationFinal reportCessna 172I · N. Myrtle Beach, SCThe pilot's inadequate pre-flight inspection which resulted in fuel exhaustion and total loss of engine power. A factor was the soft terrain at the emergency landing site.Jun 5, 1997 · N5124G · Substantial damageNTSB ANC97LA084Accident · No injuriesLimited investigationFinal reportAnderson Kitfox IV-1200 · Fairbanks, AKa seized crankshaft connecting rod bearing. A factor relating to the acciden was: the lack of suitable terrain for an emergency landing.Jun 5, 1997 · N85TA · Substantial damageNTSB SEA97LA128Accident · Minor injuriesLimited investigationFinal reportCessna 177B · Lake Powell, UTA loss of engine power for undetermined reasons.Jun 4, 1997 · N34680 · Substantial damageNTSB SEA97LA127Accident · No injuriesLimited investigationFinal reportCessna 182 · Brigham City, UTfailure of the pilot to maintain proper runway alignment during the landing. The gusty quartering crosswind was a related factor.Jun 4, 1997 · N6302A · DestroyedNTSB MIA97FA179Accident · 2 fatalField investigationFinal reportPiper J3C-65 · Asheboro, NCfailure of the pilots in both airplanes to see and/or avoid a collision with each other.Jun 4, 1997 · N804DA · 2 aircraft · Substantial damageNTSB IAD97GA081Accident · Minor injuriesFinal reportPiper PA-18-150 · Harrisonburg, VAThe pilot's preoccupation which led to fuel starvation of the selected tank and the subsequent forced landing.Jun 4, 1997 · N4310Z · Substantial damageNTSB FTW97LA210Accident · No injuriesLimited investigationFinal reportBeech 60 · Pueblo, COloss of power in the right engine and failure of the right propeller to feather for undetermined reasons. A factor relating to the accident was: the pilot's failure or inability to align the airplane with the runway during the forced landing.Jun 4, 1997 · N7396D · Substantial damageNTSB CHI97LA158Accident · No injuriesLimited investigationFinal reportKohles Kitfox III · Meadow Grove, NEfailure of the pilot to maintain directional control of the airplane during an aborted takeoff. A factor was the pilot's lack of recent experience in the make and model of airplane.Jun 4, 1997 · N515JK · Substantial damageNTSB CHI97LA156Accident · Serious injuriesLimited investigationFinal reportChampion 7ECA · Gregory, MIThe pilot's improper planning/decision. The tailwind and location of trees were related factors.Jun 4, 1997 · N5253X · Substantial damageNTSB ATL97WA079Accident · Serious injuriesForeign investigationBoeing 767-300 · Asuncion, ParaguayJun 4, 1997 · N651UA · No damageNTSB ANC97TA085Accident · No injuriesFinal reportCessna U206F · Chevak, AKThe pilot's misjudgment of the prevailing wind conditions during landing.Jun 4, 1997 · N736 · Substantial damageNTSB ANC97LA083Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Anchorage, AKthe flight instructor's delay in taking remedial action to correct an approach for a simulated emergency landing. A factor relating to the accident was: the student pilot's excessive descent rate during the approach.Jun 4, 1997 · N91855 · Substantial damageNTSB SEA97LA126Accident · No injuriesLimited investigationFinal reportGarlick UH-1H · Addy, WAThe inflight failure of the K-FLEX engine-to-gear box drive shaft and no suitable site in which to make a forced/emergency landing. A factor was the mountainous/hilly terrain.Jun 3, 1997 · N85NW · Substantial damageNTSB NYC97FA103Accident · 3 fatalField investigationFinal reportCessna 210M · Elliston, VAfailure of the PIC to maintain control of the airplane, due to spatial disorientation.Jun 3, 1997 · N9162M · DestroyedNTSB LAX97GA198Accident · 2 fatalFinal reportBeech 95-B55 · San Carlos, AZThe pilot's failure to maintain an adequate airspeed while maneuvering, which led to an inadvertent stall/spin.Jun 3, 1997 · N8KB · DestroyedNTSB CHI97LA154Accident · No injuriesLimited investigationFinal reportCessna 340A · Fort Wayne, INthe pilot did not comply with the decision height and his attention was diverted from his cockpit scan. The factors involved were the weather conditions were at landing minimums and a flight to his destination alternate was not performed.Jun 3, 1997 · N171DB · Substantial damageNTSB SEA97LA125Accident · Serious injuriesLimited investigationFinal reportCessna 402C · Rawlins, WYThe pilot's failure to maintain clearance from the terrain during the initial climb after a night takeoff. Factors include a dark night and rising terrain off the departure end of the runway.Jun 2, 1997 · N1233P · Substantial damageNTSB MIA97FA176Accident · 3 fatalField investigationFinal reportCessna 172N · Comerio, PRthe pilot's improper in-flight planning/decision, which resulted in his failure to maintain sufficient altitude/clearance from obstructions on rising terrain.Jun 2, 1997 · N4752D · DestroyedNTSB MIA97FA175Accident · 2 fatalField investigationFinal reportGrumman American AA-5B · Avon Park, FLthe pilot's failure to maintain airspeed (Vso) during an approach in instrument flight conditions.Jun 2, 1997 · N28297 · DestroyedNTSB ANC97LA081Accident · Minor injuriesLimited investigationFinal reportPiper PA-22 · Healy, AKthe pilot's inadequate compensation for wind conditions, and failure to maintain directional control of the airplane and runway alignment. Factors relating to the accident were: the crosswind, and the proximity of a creek (ravine) to the runway.Jun 2, 1997 · N3602A · Substantial damageNTSB SEA97LA124Accident · No injuriesLimited investigationFinal reportCessna 150H · Redmond, ORthe pilot's improper decision to depart on a flight without first ensuring the aircraft held sufficient fuel to reach his destination, which resulted in fuel exhaustion. Factors were the high vegetation and rocks at the location of the forced landing.Jun 1, 1997 · N50348 · Substantial damageNTSB NYC97WA104Accident · 2 fatalForeign investigationCessna TU-206G · Carroll Lake, CanadaJun 1, 1997 · N6428Z · Substantial damageNTSB NYC97LA102Accident · No injuriesLimited investigationFinal reportCessna 150 · Elkton, MDThe pilot's failure to maintain directional control, which resulted in the airplane veering right, and striking trees.Jun 1, 1997 · N22935 · Substantial damageNTSB MIA97LA177Accident · No injuriesLimited investigationFinal reportCessna T-210-N · Hollywood, FLfailure of the pilot to ensure the landing gear was locked down before landing, following an electrical system failure, resulting in the left main landing gear collapsing during landing rollout. The electrical malfunction and resultant discharged battery were…Jun 1, 1997 · N7393C · Substantial damageNTSB IAD97FA079Accident · 4 fatalField investigationFinal reportPiper PA-28-180 · Melville, NYThe pilot's failure to maintain control of the airplane. Factors to this accident were night instrument meteorological conditions with low ceiling and fog.Jun 1, 1997 · N6337J · DestroyedNTSB FTW97LA209Accident · 1 fatalLimited investigationFinal reportGiertz Vmax Probe · Lake Jackson, TXThe pilot's failure to maintain aircraft control during an approach to landing. A related factor was the pilot's lack of experience in make and model of aircraft.Jun 1, 1997 · N1200M · Substantial damageNTSB FTW97FA208Accident · 1 fatalField investigationFinal reportBell 206B · Intracoastl Cty, LAThe failure of both pilots to see and avoid each other's aircraft. Factors were the failure of the pilot of N2773A to use the available traffic advisory service and the failure of the operator of N2773A to make the use of traffic advisory services a company…Jun 1, 1997 · N115AL · 2 aircraft · Substantial damageNTSB FTW97FA207Accident · 1 fatalField investigationFinal reportCanadair F-86E MK.6 · Broomfield, COInadequate planning and decision making by the pilot in starting the aerobatic maneuver at an insufficient altitude to successfully complete the maneuver.Jun 1, 1997 · N86EX · DestroyedNTSB CHI97LA153Accident · Serious injuriesLimited investigationFinal reportPiper PA-22-108 · Alanson, MIinadequate preflight by the pilot, which resulted in fuel starvation, due to an improper fuel tank selector position. A factor relating to the accident was: the pilot's improper inflight planning/decision, which resulted in his delay or inability to flare the…Jun 1, 1997 · N5739Z · DestroyedNTSB ANC97WA080Accident · Minor injuriesForeign investigationCessna 206 · Atlin, CanadaJun 1, 1997 · N9607Z · DestroyedNTSB LAX97LA221Accident · No injuriesLimited investigationFinal reportStaudaucher S300D · Chandler, AZThe owner/pilot's decision to use automotive hardware, which had not been heat treated, and the practice of adding aluminum plates to the trailing edge of the aileron without rebalancing the flight controls, which resulted in the separation of the aileron at…May 31, 1997 · N540DH · Substantial damageNTSB LAX97LA197Accident · 1 fatalLimited investigationFinal reportRotorway 162F · Phoenix, AZthe owner/builder incorrectly installed the tail rotor drive pulley mounting scissors, overtorqued the pivot belts, did not perform the required maintenance lubrication of the pivot belts, and failed to perform adequate visual maintenance checks of these…May 31, 1997 · N176BT · DestroyedNTSB FTW97LA212Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Woodsboro, TXThe loss of engine power as result of fuel exhaustion due to the pilot's failure to refuel the airplane. A factor was the unsuitable terrain available for the pilot to execute the forced landing.May 31, 1997 · N842KG · Substantial damageNTSB CHI97LA155Accident · No injuriesLimited investigationFinal reportCessna 150 · Woodbine, IAThe pilot's inadequate preflight planning and preparation. Factors were the high temperature and high vegetation.May 31, 1997 · N60971 · Substantial damageNTSB FTW97RA213Accident · 2 fatalForeign investigationBell UH-1H · Roque, PeruMay 30, 1997 · PNP30NTSB FTW97LA214Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Santa Teresa, NMthe pilot-in-command's (PIC's) inadequate supervision of the flight by allowing the pilot-rated passenger to attempt a go-around (aborted landing) without maitaining minimum control speed (VMC), which resulted in loss of aircraft control. Factors relating to…May 30, 1997 · N36275 · Substantial damageNTSB CHI97LA152Accident · No injuriesLimited investigationFinal reportCessna 152 · Chesterfield, MOthe student pilot's failure to maintain directional control of the airplane by overcompensating with the rudder. Factors associated with the accident were the excessive airspeed and the soft terrain.May 30, 1997 · N66980 · Substantial damageNTSB NYC97LA149Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Preston, MDThe pilot's improper flare during a precautionary landing, which resulted in a hard landing. A factor in the accident was the failure of the left magneto, which resulted in a partial loss of engine power.May 29, 1997 · N4497Y · Substantial damageNTSB NYC97LA101Accident · Serious injuriesLimited investigationFinal reportHiller UH-12E · Granby, NYfailure of the pilot/owner to replace the torsional clutch as specified by the manufacturer, and subsequent failure of the helicopter's clutch, which resulted in a forced landing (autorotation). A related factor was: the encounter with trees in the emergency…May 29, 1997 · N4029S · Substantial damageNTSB LAX97LA207Accident · No injuriesLimited investigationFinal reportTaylorcraft F19 · Tracy, CAThe pilot's inadequate compensation for a crosswind gust, and his failure to maintain runway alignment after encountering the wind gust.May 29, 1997 · N3937T · Substantial damageNTSB CHI97LA150Accident · Serious injuriesLimited investigationFinal reportGrumman G164 · Illinois City, ILfailure of the pilot to see and maintain clearance from a static wire. The proximity of the wire was a related factor.May 29, 1997 · N474Y · Substantial damageNTSB ANC97LA079Accident · No injuriesLimited investigationFinal reportPiper J-5 · Wasilla, AKThe loss of engine power for an undetermined reason, and the noncertificated pilot's decision to perform a go-around after a suitable landing site had been attained. A factor associated with the accident was the rough and uneven terrain.May 29, 1997 · N31164 · Substantial damageNTSB FTW97LA206Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Greeley, COunlatching of the left outboard engine cowling latches for undetermined reason(s), which allowed the left engine cowling to separate inflight and strike the vertical stabilizer.May 28, 1997 · N491SC · Substantial damageNTSB ATL97LA076Accident · No injuriesLimited investigationFinal reportCessna 172M · Perry, GAthe pilot misjudged his distance/airspeed during the approach to land, and touched down long on the runway.May 28, 1997 · N13375 · Substantial damageNTSB SEA97LA123Accident · Minor injuriesLimited investigationFinal reportPiper PA-38 · Fruitland, UTThe pilot's failure to maintain clearance from mountainous terrain. Factors include his improper inflight decision to attempt to fly through a mountain pass under high density altitude conditions in an aircraft that was operating near the limits of its…May 27, 1997 · N2362K · Substantial damageNTSB SEA97LA122Accident · No injuriesLimited investigationFinal reportNoe SA-300 · Bountiful, UTthe pilot's failure to maintain directional control of the airplane. Related factors include: an area of standing water on a portion of the runway, and soft terrain just off the edge of the runway.May 27, 1997 · N1923S · Substantial damageNTSB NYC97LA100Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Baltimore, MDthe pilot's inadequate preflight of the airplane which failed to detect water in the fuel, and resulted in a power loss after departure due to fuel contamination.May 27, 1997 · N6927W · Substantial damage