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 NYC01LA070Accident · 1 fatalLimited investigationFinal reportWhittman Tailwind DN-1 · Grafton, WVThe pilot's improper preflight planning, which resulted in fuel exhaustion. A factor was the pilot's lack of familiarity with the airplane.NTSB CHI01LA070Accident · Serious injuriesLimited investigationFinal reportBell 206L-1 · Quincy, ILThe security guard failed to maintain clearance with the operating tail rotor.NTSB NYC01IA068Incident · No injuriesIncident investigationFinal reportAirbus Industrie A320-232 · Jamaica, NYThe pilot's decision to perform an auto rollout on a snow contaminated runway, which had not been demonstrated, and which resulted in a loss of directional control, when the capability of the autoland system to maintain directional control was exceeded.…NTSB FTW01LA052Accident · 2 fatalLimited investigationFinal reportNanchang CJ-6A · Edgewood, TXthe pilot's failure to maintain obstacle clearance with the tower guy wire while the airplane was in cruise flight. A contributing factor was the pilot's failure to update his navigation chart with the location of the tower during his preflight…NTSB CHI01LA072Accident · No injuriesLimited investigationFinal reportCessna 172P · Prairie Du Sac, WIthe improper trim setting and the pilot failed to maintain control of the airplane. A factor was the snowbank.NTSB CHI01LA069Accident · No injuriesLimited investigationFinal reportCessna 172L · Culver, INthe proper glide path not attained by both pilots during a short field landing. The snow bank was a contributing factor.NTSB SEA01LA041Accident · No injuriesLimited investigationFinal reportStinson 108-2 · Arlington, WAThe pilot's failure to maintain directional control during landing roll.NTSB SEA01LA040Accident · No injuriesLimited investigationFinal reportErcoupe 415G · Santiam, ORThe partial blockage of the carburetor main metering jet orifice by contamination of undetermined origin. Factors include a snow-covered runway upon which the pilot executed a forced landing.NTSB IAD01LA028Accident · No injuriesLimited investigationFinal reportPiper 34-200T · Bluefield, WVThe pilot's failure to enter the correct altimeter setting, which resulted in continued flight below the decision height and a subsequent collision with trees.NTSB CHI01LA071Accident · No injuriesLimited investigationFinal reportCessna 152 · Ann Arbor, MIThe CFI's delay in iniating remedial action to arrest the sink rate which developed on final approach. Factors associated with the accident were the student pilot failed to maintain a proper glidepath on final approach and the snow bank which the airplane…NTSB ATL01LA026Accident · Serious injuriesLimited investigationFinal reportCessna 172 F · Greenwood, MSAn in-flight fire for undetermined reasons. Finding: A factor is the maintenance modification was performed by company personnel prior to the flight.NTSB ATL01LA025Accident · No injuriesLimited investigationFinal reportBeech BE-23 · Columbus, MSThe pilots failure to maintain directional control of the airplane ,and subsequently resulted in the collapse of the right main landing gear.NTSB IAD01LA029Accident · No injuriesLimited investigationFinal reportPiper PA 46-350P · Chillicothe, OHpilot's improper pre-flight planning and failure to follow the published checklist procedures, which resulted in ice and snow not being removed from the wings prior to take-off.NTSB DEN01LA043Accident · No injuriesLimited investigationFinal reportMaule M-7-235C · Durango, COfailure by the pilot to maintain directional control of the aircraft during landing roll. A factor was the pilot's lack of experience in aircraft make and model.NTSB ATL01LA023Accident · Serious injuriesLimited investigationFinal reportCessna 172SP · Austell, GAThe pilots failure to follow instrument flight procedures and descended below the published the minimum descent altitude and subsequently collided with trees short of the runway.NTSB ANC01LA031Accident · No injuriesLimited investigationFinal reportCessna 207 · Kongiganak, AKThe pilot's inadequate compensation for wind conditions during the takeoff roll. A factor associated with the accident was a crosswind.NTSB LAX01LA078Accident · Serious injuriesLimited investigationFinal reportAyres S2R-T34 · Holtville, CAThe pilot's failure to maintain clearance from the wires. Contributing to the accident was the pilot's inadequate preflight inspection.NTSB DEN01LA042Accident · No injuriesLimited investigationFinal reportCessna P210N · Pagosa Springs, COfailure to maintain directional control of the aircraft after an encounter with adverse weather during landing roll. A factor was ground fog.NTSB CHI01LA068Accident · No injuriesLimited investigationFinal reportCessna 150G · La Rose, ILthe pilot's inadequate airplane preflight and the snow covered terrain. A factor was the fuel exhaustion.NTSB CHI01FA067Accident · 2 fatalField investigationFinal reportCessna 182B · Piedmont, KSThe pilot's failure to maintain obstacle clearance. Contributing factors were low altitude maneuvering and the transmission wire.NTSB ATL01LA024Accident · No injuriesLimited investigationFinal reportCessna 152 · St. Augustine, FLThe pilots failure to maintain directional control during the landing roll, which resulted in the collision with the airport sign.NTSB ANC01LA030Accident · No injuriesLimited investigationFinal reportBell 206L-1 · Tyonek, AKThe pilot's failure to maintain adequate tail rotor clearance while maneuvering to land.NTSB MIA01WA066Accident · 4 fatalForeign investigationBeech 95-55 · Dijon, FranceNTSB IAD01WA027Accident · Serious injuriesForeign investigationBeech 95-D55 · Rendsburg-Schac, GermanyNTSB SEA01IA039Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas DC-8-71F · Seattle, WAA malfunctioning relay in the aircraft's flight management system (FMS) switching matrix and associated false "on course" indication on the captain's course deviation indicator (CDI), resulting in proper localizer course alignment not being obtained or…NTSB NYC01LA132Accident · 1 fatalLimited investigationFinal reportPiper PA-22-108 · Falmouth, MAThe pilot's improper decision to takeoff and attempt VFR flight in IMC conditions.NTSB LAX01LA074Accident · No injuriesLimited investigationFinal reportCessna TR182 · Concord, CAThe failure of the pilot to maintain clearance from buildings during taxi.NTSB CHI01LA065Accident · No injuriesLimited investigationFinal reportLuscombe 8E · North Platte, NEThe inadvertent ground loop. Factors associated with the accident were the pilot selected the wrong runway on which to land, the quartering tailwind, the icy runway, and the snow bank which the airplane contacted.NTSB ATL01LA022Accident · Minor injuriesLimited investigationFinal reportLake LA-4-200 · Orlando, FLThe other maintenance personnel's failure to complete prescribed inspections that resulted in the failure of a fuel block drain assembly fitting , corrosion of the battery grounding strap and the subsequent flash explosion.NTSB SEA01LA044Accident · No injuriesLimited investigationFinal reportBell 206B · McMinnville, ORThe pilot's failure to apply adequate power during a practice autorotation. A factor contributing to the accident was a rough/uneven area on the asphalt landing surface.NTSB LAX01LA075Accident · No injuriesLimited investigationFinal reportCessna T210L · San Luis Obispo, CAThe failure of the other pilot to ensure adequate taxi clearance between aircraft.NTSB LAX01FAMS1Accident · 1 fatalMissing aircraftFinal reportCessna 172N · Monterey, CAUndetermined.NTSB FTW01LA050Accident · Serious injuriesLimited investigationFinal reportCessna 210M · Burnet, TXthe pilot's failure to maintain proper glide path during a practice instrument approach, which resulted in an in-flight collision with terrain. Contributory factors to the accident were the dark night light condition and the safety pilot's inadequate…NTSB DEN01FA041Accident · 9 fatalField investigationFinal reportBeech 65-A90 · Lake Point, UTthe pilot's exercise of poor judgment and his failure to maintain a safe altitude/clearance above the water. Contributing factors were the weather conditions that included low ceiling and visibility obscured by snow and mist, an inadequately equipped airplane…NTSB ATL01LA020Accident · No injuriesLimited investigationFinal reportPiper PA-18-A-150 · Sun City, FLThe loss of engine power for undetermined reasons, a factor was weather conditions favorable for carburetor icingNTSB MIA01FA060Accident · 2 fatalField investigationFinal reportPiper PA-28R-180 · Bethel, NCthe pilot's failure to maintain control of the airplane due to spatial disorientation, which resulted in an in-flight collision with power lines and the subsequent impact with terrain. A factor in this accident was: the pilot's lack of recent instrument…NTSB LAX01LA077Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Atwater, CAThe student's failure to maintain directional control while landing in a crosswind, his improper compensation for wind conditions, and the flight instructor's inadequate flight supervision.NTSB LAX01LA076Accident · No injuriesLimited investigationFinal reportPurvis/Thorpe T-18 · Chiriaco Summit, CAThe dual student's improper recovery from a bounced landing, his failure to maintain directional control during the go-around, and the flight instructor's inadequate supervision of the go-around attempt.NTSB IAD01LA026Accident · No injuriesLimited investigationFinal reportAyres S2R · Crewe, VAthe loss of engine power due to the pilot's inadequate preflight planning and exhaustion of his fuel supply.NTSB ATL01FA021Accident · Serious injuriesField investigationFinal reportLearjet LJ-60 · Troy, ALOn ground collision with deer during landing roll, and the inadvertent thrust reverser stowage caused by the damage to the landing gear squat switch by the collision, and subsequent application of forward thrust during rollout.NTSB NYC01LA066Accident · Serious injuriesLimited investigationFinal reportMooney M20C · Somerset, MAThe pilot's inadequate visual lookout. A factor was the dusk lighting conditions.NTSB MIA01LA062Accident · Serious injuriesLimited investigationFinal reportPiper PA-23-160 · Milton, FLa loss of right engine power due to chaffed and frayed wiring on the right and left magnetos on the right engine resulting in a forced landing, an inadvertent stall, and subsequent impact with the ground.NTSB CHI01FA064Accident · 2 fatalField investigationFinal reportCessna 172K · Martinsville, INThe pilots decision not to fly to the alternate airport, his decision to continue the flight in known adverse weather conditions, spatial disorientation by the pilot, and his failure to maintain aircraft control. Factors were the low ceilings, the dark night,…NTSB ANC01LA029Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Anchorage, AKThe pilot's improper use of the carburetor heat control. Factors in the accident were the presence of carburetor icing conditions, and snow-covered terrain that was unsuitable for a forced landing.NTSB NYC01LA065Accident · No injuriesLimited investigationFinal reportCessna 182P · Angola, NYThe pilot's misjudged clearance over an obstacle.NTSB ATL01FA019Accident · 1 fatalField investigationFinal reportCessna 206H · Vandiver, ALThe pilot's inflight decision to continued visual flight into instrument meteorological conditions resulted in the inflight collision with trees. Low ceilings and trees were factorsNTSB FTW01LA049Accident · No injuriesLimited investigationFinal reportde Havilland DHC-6-300 · Fort Worth, TXthe loss of power to both engines for undetermined reasons during approach. Contributing factors were the pilot's failure to properly position the fuel selector in accordance with the landing checklist and the lack of suitable terrain for the forced landing.NTSB SEA01LA037Accident · Serious injuriesLimited investigationFinal reportGrumman American AA-1B · Cottage Grove, ORThe flight instructor's failure to ensure (supervision) the student had an adequate supply of fuel available, and the student's failure to refuel the aircraft sufficently resulting in a fuel starvation/exhaustion condition and total power loss. Contributing…NTSB LAX01LA072Accident · Minor injuriesLimited investigationFinal reportBeech V35B · Mesa, AZThe pilot's improper fuel management in cruise flight that resulted in a loss of engine power, because of fuel starvation, and a collision with a fence during the subsequent forced landing.NTSB FTW01IA051Incident · No injuriesIncident investigationFinal reportSaab 340B · San Antonio, TXthe ingestion of ice/slush into both engines, which resulted in dual engine power fluctuations.