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 ATL98FA080Accident · 5 fatalField investigationFinal reportBell 206L-3 · Indian Trail, NCThe pilot's failure to maintain altitude while operating in adverse weather. A contributing factor was the incoming fog and high tension static wire.NTSB ANC98LA053Accident · No injuriesLimited investigationFinal reportBellanca 8GCBC · Minchumina, AKThe pilot's failure to maintain directional control while landing. A factor associated with this accident was the pilot's inadequate recovery from a bounced landing.NTSB SEA98LA082Accident · Serious injuriesLimited investigationFinal reportCessna 150L · Sandpoint, IDLoss of consciousness by the pilot-in-command/flight instructor, resulting in loss of aircraft control and subsequent collision with terrain.NTSB NYC98LA116Accident · Serious injuriesLimited investigationFinal reportCessna 150L · Blakeslee, PAThe pilot's inadequate preflight resulting in fuel exhaustion. A factor was the pilot's failure to refuel the aircraft prior to departing.NTSB MIA98LA181Accident · No injuriesLimited investigationFinal reportAir Tractor AT-401 · Rich, MSa loss of engine power for an undetermined reason, resulting in a forced landing and subsequent impact with rough terrain.NTSB LAX98LA173Accident · No injuriesLimited investigationFinal reportJohn H. Korb Jr. Kitfox III · Carson City, NVThe failure of the right landing gear shock cord because of ultraviolet deterioration in an area of abraded outer fabric, that resulted in a loss of directional control on landing and subsequent ground collision. Factors were the owner/builder's failure to…NTSB LAX98FA171Accident · 2 fatalField investigationFinal reportVans RV-8 · Ripley, CAthe intentional or unintentional sudden application of aft elevator control by an undetermined aircraft occupant that exceeded the design stress limits of the aircraft. The aircraft gross weight, which exceeded the maximum allowable for aerobatics, and…NTSB IAD98LA062Accident · Serious injuriesLimited investigationFinal reportPiper PA-28 · Minden, NYThe pilot's failure to maintain adequate airspeed which resulted in an inadvertent stall/mush. A related factor was the rough/uneven runway.NTSB FTW98LA254Accident · No injuriesLimited investigationFinal reportCessna 172A · Ten Sleep, WYThe student pilot's failure to select a proper touchdown point. A factor was his lack of recent experience conducting solo flight operations.NTSB FTW98LA246Accident · No injuriesLimited investigationFinal reportMooney M20F · Moriarty, NMthe unfavorable wind condition, and failure of the pilot to adequately compensate for the wind condition during the landing flare.NTSB FTW98LA241Accident · No injuriesLimited investigationFinal reportMader WAG-AERO 2+2 · Hurricane, UTAn encounter with high vegetation and unsuitable terrain during a forced landing. A factor was a partial failure of the engine's exhaust stack during flight.NTSB FTW98LA237Accident · No injuriesLimited investigationFinal reportCessna 170A · Provo, UTfailure of the pilot to maintain directional control of the airplane. A related factor was the right quartering tailwind gust.NTSB FTW98FA239Accident · Serious injuriesField investigationFinal reportBell 206L-3 · Springdale, ARThe failure of maintenance personnel to properly assemble the engine's accessory gearbox, which resulted in a total loss of engine power due to partial blockage of the main oil passage by an o-ring. The blockage reduced oil flow to the turbine shafting, which…NTSB FTW98FA238Accident · 1 fatalField investigationFinal reportBell 47G · Bixby, OKThe pilot's failure to maintain clearance from the power lines.NTSB CHI98LA173Accident · Serious injuriesLimited investigationFinal reportCessna 310R · Augusta, KSthe pilot's inadequate evaluation of the current local weather conditions and his failure to maintain a climb after takeoff. Factors related to the accident were the fog, the powerlines, and spatial disorientation.NTSB ATL98LA079Accident · No injuriesLimited investigationFinal reportBurkhart Grob G-103 · Cordele, GAThe pilot's improper descent rate that led to a hard landing and porpoise, and his improper recovery from the ensuing bounced landing, resulting in the eventual separation of the empennage. A factor was the updraft.NTSB ANC98LA055Accident · Minor injuriesLimited investigationFinal reportDouglas DC-3C · Anchorage, AKThe pilot's inadequate in-flight planning/decision which resulted in fuel exhaustion and subsequent loss of engine power. A related factor was the soft, marshy terrain at the forced landing area.NTSB NYC98LA115Accident · No injuriesLimited investigationFinal reportCessna 177B · Brogue, PAfailure of the pilot to maintaining proper runway alignment during an aborted landing (go-around). Related factors were: the pilot's improper recovery from a bounced landing, inadvertent porpoise, and the small trees encroaching into the runaway environment.NTSB NYC98LA114Accident · Serious injuriesLimited investigationFinal reportAerostar S81A · Strasburg, PAA fire of undetermined origin.NTSB NYC98FA111Accident · 2 fatalField investigationFinal reportPiper PA-28RT-201 · Lincoln, MAThe pilot's failure to maintain airspeed.NTSB LAX98LA174Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Sedona, AZThe pilot's failure to maintain directional control during the landing rollout. A factor was the gusty wind.NTSB LAX98LA172Accident · 4 fatalLimited investigationFinal reportPiper PA-28-161 · Half Moon Bay, CAThe non-instrument rated pilot's loss of aircraft control due to spatial disorientation in dark night conditions.NTSB FTW98LA244Accident · No injuriesLimited investigationFinal reportBurkhart Grob 103 · Briggs, TXThe pilot's misjudgment of the distance and altitude. Factors were the lack of thermal lift and his diverted attention while on downwind.NTSB FTW98LA236Accident · No injuriesLimited investigationFinal reportGrumman G-164 · Huntington, UTThe pilot's failure to maintain adequate airspeed.NTSB ATL98LA078Accident · No injuriesLimited investigationFinal reportLearjet 24-B · Orlando, FLThe first officer's failure to perform proper emergency braking procedures.NTSB ANC98LA054Accident · Minor injuriesLimited investigationFinal reportPiper PA-18 · Glennallen, AKThe pilot's inadequate preflight of the airplane's fuel system, and presence of water in the fuel system.NTSB ANC98LA052Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Cold Bay, AKThe pilot's inadequate compensation for wind conditions. A factor associated with this accident was the presence of a crosswind.NTSB MIA98LA167Accident · No injuriesLimited investigationFinal reportNorth American T-28B · Spartanburg, SCThe pilot's misjudgment of speed and distance, and his delay in the use of brakes. Contributing to the accident was a thunderstorm, a wet runway, the pilot's self-induced pressure, and his inadequate inflight planning/decision.NTSB LAX98LA170Accident · No injuriesLimited investigationFinal reportRobinson R22B · San Luis Obispo, CAThe flight instructor's inadequate compensation for wind conditions, and his failure to maintain aircraft control. Contributing was wind gusts.NTSB ATL98LA077Accident · No injuriesLimited investigationFinal reportCessna 140 · Holt, FLLoss of engine power for undetermined reasons. A factor was the unsuitable terrain.NTSB ANC98LA056Accident · No injuriesLimited investigationFinal reportCessna 207 · Quinhagak, AKThe pilot's failure to maintain directional control of the airplane, and his premature liftoff, resulting in a collision with a runway light fixture. Factors in the accident were wet runway conditions, and a rough and uneven runway surface with potholes.NTSB SEA98FA081Accident · 3 fatalField investigationFinal reportCessna P206C · Dubois, IDAttempted VFR flight into IMC and a loss of aircraft control. An inadequate weather evaluation and drug impairment were factors.NTSB LAX98LA176Accident · No injuriesLimited investigationFinal reportPiper PA-44-180 · Fresno, CAThe dual's student improper flare that led to the right main landing gear collapsing. A related factor in the accident was the instructor pilot's inadequate supervision.NTSB LAX98FA169Accident · Serious injuriesField investigationFinal reportMcDonnell Douglas DC-10-10 · Los Angeles, CAThe contaminated strain gage, which resulted in shorting of the strain gage's terminal lugs which lead to excessive autopilot initiated elevator movement, and excessive elevator actuation during recovery by the captain. Contributing factors were the failure…NTSB FTW98LA235Accident · No injuriesLimited investigationFinal reportBell 206BIII · Hurst, TXThe pilot's delayed recovery from a simulated autorotative landing.NTSB CHI98LA230Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Red Lake Falls, MNa locked brake for undetermined reasons.NTSB CHI98LA170Accident · 2 fatalLimited investigationFinal reportKreatz Genesis · Maple Lake, MNthe pilot inadvertently stalled the airplane. A factor was the failed reduction drive belts.NTSB CHI98LA158Accident · No injuriesLimited investigationFinal reportCessna 150 · Griffith, INThe aircraft's speed not maintained by the pilot, which resulted in the aircraft stalling in close proximity to the ground.NTSB SEA98LA080Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-401 · Idaho Falls, IDThe pilot's failure to maintain clearance from a power transmission line during an aerial application flight. Factors include a power line located just beyond the boundary of the field being sprayed, and the pilot's incorrect judgement of the distance between…NTSB LAX98LA168Accident · No injuriesLimited investigationFinal reportCessna T210M · Santa Barbara, CAThe pilot's mismangement of the fuel by the improper position of the fuel tank selector.NTSB LAX98LA166Accident · Minor injuriesLimited investigationFinal reportMcDonnell Douglas 520N · Lanai City,Maui, HIAn oil starvation failure of the number 5 bearing for undetermined reasons.NTSB FTW98LA279Accident · No injuriesLimited investigationFinal reportSchweizer 269C · San Angelo, TXThe improper touchdown executed by the flight instructor, which resulted in the tail rotor impacting the ground.NTSB FTW98LA234Accident · Minor injuriesLimited investigationFinal reportHarding Revolution MINI-500B · Grove, OKThe improper alignment of the main drive belt by the owner/pilot/mechanic, which resulted in the failure of the main drive belt. A factor was the lack of suitable terrain for the forced landing.NTSB FTW98LA233Accident · Serious injuriesLimited investigationFinal reportAeronca 7AC · Sheridan, ARThe inadvertent engine start due to the pilot's failure to ensure that the magneto switch was in the OFF position when he was attempting to clear the flooded engine. A factor was the pilot's improper starting procedure, which resulted in flooding the engine.NTSB CHI98LA156Accident · No injuriesLimited investigationFinal reportCessna 182 · Independence, MOA loss of engine power due to the separation of the induction system balance tube coupling from the intake manifold tube assembly. A related factor was the soft field.NTSB SEA98LA079Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Idaho Falls, IDThe pilot's inadequate inflight decision to land with a tailwind and his failure to maintain aircraft control. Also contributing was the pilot's improper setting of the fuel mixture which resulted in a partial loss of engine power.NTSB SEA98FA078Accident · 2 fatalField investigationFinal reportPiper PA-31T1 · Great Falls, MTThe flight crew's failure to maintain aircraft control.NTSB SEA98FA077Accident · No injuriesField investigationFinal reportGarlick UH-1H · Hope, IDFailure of a misaligned main bearing in the engine. Factors include returning a previously unairworthy-tagged engine to service by the operator's maintenance personnel without sufficient information to identify and correct an unknown engine deficiency.NTSB LAX98LA165Accident · Serious injuriesLimited investigationFinal reportWaco YMF · Sedona, AZThe failure of the pilot to secure the ignition system and magnetos in the off position before asking the ground crewman to rotate the propeller.NTSB IAD98FA061Accident · 1 fatalField investigationFinal reportSukhoi SU-29 · Manassas, VAThe pilot's failure to maintain adequate altitude/clearance during an aerobatic maneuver.