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 SEA04CA194Accident · No injuriesData collectionFinal reportCessna 152 · Friday Harbor, WAThe pilot's delay in executing an aborted landing and his failure to obtain altitude/clearance from trees during the aborted landing. A factor was the pilot's failure to obtain the proper touchdown point as a result of his high airspeed on approach.NTSB DFW05CA021Accident · No injuriesData collectionFinal reportBellanca BL-17-30A · Roanoke, TXThe disconnection of the engine mixture control cable due to improper maintenance which resulted in a loss of engine power.NTSB CHI04LA280Accident · Serious injuriesLimited investigationFinal reportCessna T210L · Kingman, KSThe lack of engine oil due to the mechanic's improper maintenance in not securing the loose "B" nut for the oil pressure line to the turbocharger leading to the loss of engine power while maneuvering. An additional cause was the unsuitable terrain the pilot…NTSB CHI04FA284Accident · 1 fatalField investigationFinal reportCessna 182Q · Morris, MNThe pilot's inadequate weather evaluation that resulted flight into night instrument meteorological conditions and a subsequent loss of aircraft control. Factors to the accident were the pilot's lack of recent night experience and the low cloud ceiling at…NTSB NYC04LA218Accident · No injuriesLimited investigationFinal reportCessna 152 · Dayton, OHThe student pilot's inadequate preflight and in-flight planning, which resulted in a total loss of engine power during cruise flight, due to fuel exhaustion.NTSB DEN04LA148Accident · No injuriesLimited investigationFinal reportSmith, Ted Aerostar 601P · Broomfield, COthe pilot's improper in-flight planning/decision to accept a short traffic pattern and the improper flare resulting in a hard landing.NTSB CHI04CA288Accident · No injuriesData collectionFinal reportAeronca 7BCM · St. James, MOThe pilot's failure to maintain clearance from trees during the go-around. Factors were the sun glare and the trees.NTSB ATL04CA193Accident · No injuriesData collectionFinal reportCessna 177 · Anderson, SCThe pilot's inadequate preflight planning of fuel required for the flight and his improper in-flight decision, which resulted in a loss of engine power due to fuel exhaustion.NTSB ANC04IA115Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas MD-82 · Anchorage, AKThe loss of engine power due to the flight crew's failure to follow published procedures and directives, and an inadequate preflight inspection, which resulted in ice ingestion into the left engine during the takeoff roll. Factors associated with the incident…NTSB NYC04LA217Accident · 1 fatalLimited investigationFinal reportFirefly Galaxy 9 · Lewisburg, WVThe pilot's improper decision to attempt to board the balloon while it was ascending.NTSB MIA04LA129Accident · Minor injuriesLimited investigationFinal reportBell 206B3 · Starkville, MSThe operator's inadequate maintenance inspections and the pilot's inadequate preflight inspection, which resulted in the helicopter being operated with a contaminated fuel system, that resulted in fuel starvation, and the loss of engine power.NTSB LAX04LA331Accident · No injuriesLimited investigationFinal reportSchweizer 269C-1 · Burbank, CAthe failure of maintenance personnel to correctly service the forward landing gear strut dampers in accordance with the manufacturer's maintenance instructions.NTSB LAX04FA330Accident · Serious injuriesField investigationFinal reportBushmaster 2000 · Fullerton, CAthe inadequate preflight inspection by the pilot-in-command, where the pilot failed to remove the makeshift gust lock attached to the rudder and left elevator of the airplane. As a result, the airplane veered off the runway surface during the takeoff roll,…NTSB LAX04FA329Accident · 5 fatalClass 1 · FieldFinal reportBell 206B · Kalaheo, HIThe pilot's decision to continue flight under visual flight rules into an area of turbulent, reduced visibility weather conditions, which resulted in the pilot's spatial disorientation and loss of control of the helicopter. Contributing to this accident was…NTSB DFW05WA014Accident · 2 fatalForeign investigationGarlick UH-1H · San Felipe, ChileNTSB CHI04LA279Accident · Serious injuriesLimited investigationFinal reportErnst Pitts S2E · Hanover, INThe pilot's failure to maintain clearance to the trees and terrain during the aerobatic maneuver. Contributing factors were the pilot's decision to perform a low-level, ostentatious aerobatic display and the trees.NTSB CHI04CA291Accident · No injuriesData collectionFinal reportJohnson Titan Tornado I · Carlton, MNThe pilot's failure to abort the takeoff. Factors to the accident included the diminished takeoff performance due to the incorrect propeller pitch setting and the tree that the airplane impacted.NTSB CHI04CA287Accident · No injuriesData collectionFinal reportCessna 182P · Washington, MOThe misjudged flare by the student pilot and the inadequate supervision by the flight instructor. A factor was the overload failure of the nose landing gear.NTSB ANC04LA120Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Nenana, AKThe loss of engine power during takeoff-initial climb for an undetermined reason, which resulted in an emergency descent and hard landing.NTSB ANC04CA114Accident · No injuriesData collectionFinal reportde Havilland DHC-2 · Willow, AKThe pilot's selection of an unsuitable landing area, which resulted in an on-ground collision with trees during the landing roll. A factor associated with the accident were trees.NTSB NYC04LA219Accident · Serious injuriesLimited investigationFinal reportde Havilland DHC-22A · Richmond, VAThe pilot's inadequate preflight inspection which resulted in fuel contamination and a subsequent loss of engine power. A factor in the accident was the pilot's failure to maintain airspeed while attempting a forced landing which resulted in an inadvertent…NTSB NYC04CA216Accident · Minor injuriesData collectionFinal reportConsolidated Aeronautics Lake LA-4-200 · New Milford, CTThe pilot's improper flair, which resulted in a nose over.NTSB CHI04LA278Accident · Serious injuriesLimited investigationFinal reportCessna 208B · Gwinner, NDThe pilot's failure to maintain altitude during the circling maneuver. Contributing factors were the pilot's improper decision to execute the approach when weather conditions were below minimums and the low light (dark night) conditions.NTSB ATL04WA194Accident · 3 fatalForeign investigationPiper PA-28-181 · Nordhorn-Lingen, GermanyNTSB SEA04CA193Accident · No injuriesData collectionFinal reportPiper PA-28 · Deer Harbor, WAThe pilot's failure to perform remedial action during the landing sequence. A factor contributing to the accident was the wet runway surface.NTSB MIA04FA128Accident · 4 fatalField investigationFinal reportCessna R182 · Milton, FLThe pilots operation of the airplane with known deficiencies in the equipment based on witness statements describing an excessive rpm drop and rough running engine after starting, during the engine run-up, and after becoming airborne, his failure to abort the…NTSB FTW04FA243Accident · 2 fatalField investigationFinal reportCessna 421C · Bee Caves, TXThe pilot's improper positioning of the fuel selector valves, which resulted in a loss of power to the left engine due to fuel exhaustion. After the power loss, the pilot failed to follow checklist procedures and did not secure (feather) the left propeller,…NTSB FTW04CA240Accident · No injuriesData collectionFinal reportCarter-Jones Volmer Sportsman · Grand Prarie, TXThe pilot's failure to complete a pre-landing checklist, which resulted in a gear down landing on the water. A factor was the pilot's diverted attention as a result of abnormal engine indications.NTSB CHI04WA277Accident · 1 fatalForeign investigationPiper PA-28-181 · Wilhelmshausen, GermanyNTSB CHI04CA281Accident · No injuriesData collectionFinal reportPiper PA-28-140 · Jackson, MICollision with a deer when it crossed the airplane's path during landing rollout. Factors were low lighting (night) conditions and the pilot's inability to maintain directional control due to the collision.NTSB ANC04LA113Accident · Serious injuriesLimited investigationFinal reportBritten-Norman BN-2A · Kodiak, AKThe pilot's inadequate compensation for wind conditions, and his intentional flight into adverse weather conditions, which resulted in a loss of control and collision with terrain during takeoff-initial climb. Factors contributing to the accident were high…NTSB LAX04LA328Accident · Minor injuriesLimited investigationFinal reportCessna 210B · Flagstaff, AZthe pilot's improper leaning procedures and delayed decision to abort the takeoff when it became obvious that the engine was not developing full power. A factor in the accident was the pilot's decision to use a runway with a quartering tailwind.NTSB IAD04LA048Accident · Minor injuriesLimited investigationFinal reportBoeing A75N (PT17) · Bayport, NYThe failure of a magneto, which resulted in a loss of engine power. Factors in the accident were the pilot's decision to take off downwind, which resulted in reduced airplane performance, and the tail wind.NTSB DEN04LA147Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Provo, UTthe pilot's premature liftoff which resulted in failure to attain airspeed which resulted in a stall.NTSB ATL04CA191Accident · Serious injuriesData collectionFinal reportPinkham Challenger II · Lancaster, SCA partial loss of engine power in-flight due to water ingestion and his misjudgment of obstacle clearance resulting in a collision with trees and the ground. A factor in the accident was the pilot's failure to follow the manufactures instructions for…NTSB FTW04CA242Accident · Minor injuriesData collectionFinal reportPiper PA-28-181 · Haskell, TXThe pilot's improper inflight planning which resulted in a loss of engine power due to fuel exhaustion. A factor was the lack of suitable terrain for the forced landing.NTSB DEN04LA146Accident · No injuriesLimited investigationFinal reportSmith Aerostar 601P · Lordsberg, NMaircraft control not maintained by the pilot. Contributing to the accident was the dirt devil/whirlwind.NTSB CHI04LA265Accident · Serious injuriesLimited investigationFinal reportKenny Mariner-MF Boat · Eagle River, WIThe pilot's inability to maintain control of the aircraft during flight for undetermined reasons.NTSB ATL04FA190Accident · 2 fatalField investigationFinal reportPiper PA-32R-301 · Euharlee, GAThe pilot's failure to maintain adequate control of the airplane, which resulted in the pilot exceeding the design limits of the airplane and subsequent in-flight separation.NTSB SEA04LA195Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Seattle, WAThe failure of the pilot to maintain clearance with the parked airplane while taxiing. A factor contributing to the accident was the pilot's inadequate preflight planning.NTSB SEA04GA192Accident · 3 fatalFinal reportCessna U206G · Essex, MTThe pilot's misidentification of the airplane's location, which resulted in his improper decision to fly into the wrong drainage, and his failure to maintain terrain clearance while executing a turn to reverse course after he realized his navigational error.…NTSB LAX04CA326Accident · No injuriesData collectionFinal reportIar Sa Brasov 823 · Denair, CAthe pilot's failure to verify the fuel quantity on board prior to departure, which resulted in fuel exhaustion and loss of engine power due to an inadequate fuel supply.NTSB CHI04LA262Accident · Minor injuriesLimited investigationFinal reportNavion Navion G · Knox, INA loss of engine power for undetermined reasons. Contributing to the accident were the unsuitable terrain encountered, the dark night conditions, and the ditch.NTSB ANC04FAMS2Accident · 5 fatalMissing aircraftFinal reportde Havilland DHC-2 · Sitka, AKReason for occurrence is undetermined. The airplane is missing.NTSB SEA04FA191Accident · 1 fatalField investigationFinal reportCessna 172D · Mountain Home, IDThe pilot's failure to maintain clearance from high terrain while maneuvering. High terrain was a factor.NTSB NYC04WA215Accident · 1 fatalForeign investigationRobinson R-44 · Kentallen, Scot, United KingdomNTSB NYC04LA214Accident · Serious injuriesLimited investigationFinal reportRyan ST3KR · Bealeton, VAThe improper installation of fuel lines by maintenance personnel resulting in a total loss of engine power.NTSB LAX04LA324Accident · No injuriesLimited investigationFinal reportCirrus SR-22 · Peters, CAThe pilot's decision to continue flight into adverse weather and the subsequent encounter with the outer boundaries of a level 5 thunderstorm, which resulted in his loss of control of the airplane.NTSB IAD04WA049Accident · 4 fatalForeign investigationCessna 182R · Montreux, SwitzerlandNTSB FTW04CA241Accident · No injuriesData collectionFinal reportPiper J3C-65 · Louise, TXThe pilot's inadvertent positioning of the fuel shutoff valve resulting in the fuel starvation of the engine and the subsequent loss of engine power. A contributing factor was the lack of suitable terrain for the forced landing.