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 MIA93LA077Accident · No injuriesLimited investigationFinal reportBeech N35 · Fort Meade, FLThe collision with a road sign during a forced landing. Contributing to the accident was the total loss of engine power due to fatigue failure of the crankshaft.NTSB MIA93LA076Accident · Minor injuriesLimited investigationFinal reportHuddleston-Bell 47G2 · Rio Grande, PRPoor in-flight planning by the pilot-in-command. Contributing to the accident was the flight's lack of total experience.NTSB FTW93FA092Accident · 2 fatalField investigationFinal reportCessna 340A · Center Point, TXInadvertent stall. Factors were the weather and the light conditionsNTSB DEN93LA028Accident · No injuriesLimited investigationFinal reportMaule M-5-220C · Englewood, COFailure by the pilot to maintain control of the aircraft. A factor was: lack of experience in type of aircraft.NTSB CHI93LA195Accident · No injuriesLimited investigationFinal reportCessna A150L · Blaine, MNThe failure of the pilot of the Cessna 150, N6059J, and the pilot of the challenger to see and avoid each other.NTSB CHI93LA100Accident · Serious injuriesLimited investigationFinal reportLuscombe 8A · Mason City, IAExcessive braking by the dual student.NTSB CHI93LA099Accident · No injuriesLimited investigationFinal reportCessna 150M · Stanley, NDThe student pilot's delayed use of carburetor heat. The soft terrain in the landing area was a factor.NTSB BFO93LA040Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · Napoleon, OHThe intentional stall resulting in a hard landing. Contributing to the accident was the premature flare which led to an exceeded proper touchdown point and the student pilot's lack of overall experience.NTSB BFO93LA036Accident · No injuriesLimited investigationFinal reportPiper PA-18-135 · Boonville, NYThe pilot failed to compensate for wind conditions and encountered a stall. The windshear was a factor.NTSB ANC93LA038Accident · No injuriesLimited investigationFinal reportCessna U206A · Willow, AKThe abrupt aircraft handling by the pilot in command. Factors were the collapse of the nose gear and the soft, snow covered terrain.NTSB SEA93LA069Accident · Minor injuriesLimited investigationFinal reportCessna T-210L · Ogden, UTThe loss on engine power from fuel exhaustion due to the inadequate preflt planning/preparation by the PIC and his failure to maintain proper airspeed during an emergency forced landing.NTSB MIA93LA075Accident · Minor injuriesLimited investigationFinal reportCessna 150E · Blountstown, FLInadequate visual lookout by the pilot resulting in failure to avoid the powerline.NTSB LAX93WA145Accident · 3 fatalForeign investigationPiper PA-28-235 · Loreto, MexicoNTSB CHI93LA098Accident · No injuriesLimited investigationFinal reportCessna 172M · Grain Valley, MOThe student pilot's improper recovery from a bounced landing and failure to maintain directional control.NTSB BFO93LA043Accident · No injuriesLimited investigationFinal reportCessna 150 · Knoxville, PAThe pilot's failure to maintain directional control. Contributing to the accident was the pilot's failure to plow the runway adequately.NTSB BFO93LA035Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Xenia, OHLoss of partial power for undetermined reasons.NTSB BFO93FA034Accident · 1 fatalField investigationFinal reportCessna 180F · Brewer, MELoss of engine power due to undetermined reasons, and the failure of the pilot to maintain adequate airspeed during the forced landing which resulted in a stall.NTSB ANC93LA037Accident · No injuriesLimited investigationFinal reportPiper PA-32-301 · Egegik, AKThat the lift off airspeed was not attained by the pilot in command because of the snow covered runway.NTSB LAX93LA138Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Chandler, AZLoss of engine power for an undetermined reason.NTSB CHI93LA112Accident · No injuriesLimited investigationFinal reportTaylorcraft BC12-D · Brainerd, MNThe pilot's improper flare which resulted in a bounced, hard landing and the subsequent loss of directional control.NTSB SEA93LA067Accident · No injuriesLimited investigationFinal reportBeech C-99 · Seattle, WAThe improper starting procedure by the pilot of the Aeronca. A factor contributing to the accident was inadequate communications by the pilot of the Aeronca.NTSB CHI93LA097Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Marshfield, WIThe student pilot's failure to maintain aircraft directional control during the takeoff ground run.NTSB CHI93LA096Accident · No injuriesLimited investigationFinal reportCessna 172K · Jackson, MIThe pilot's failure to maintain directional control.NTSB CHI93LA095Accident · No injuriesLimited investigationFinal reportCessna 150M · Canton, MIThe student pilot's failure to maintain directional control.NTSB LAX93LA137Accident · No injuriesLimited investigationFinal reportBeech A36 · Santa Ana, CAThe pilot's inadequate compensation for the existing wind conditions and his failure to maintain an adequate approach reference airspeed. Factors in the accident were the pilot's low experience in the aircraft.NTSB LAX93LA136Accident · No injuriesLimited investigationFinal reportCessna T188C · Delhi, CAThe pilot selected unsuitable terrain for takeoff and failed to maintain directional control of the aircraft. A factor in the accident was the standing water on the runway.NTSB BFO93FA033Accident · 1 fatalField investigationFinal reportBeech E18S · Lemont, PAImproper inflight planning decision by the pilot, and his failure to maintain proper altitude during the approach. Factors related to the accident were darkness, adverse weather conditions, and high terrain.NTSB MIA93FA073Accident · No injuriesField investigationFinal reportBoeing 757-232 · Fort Lauderdale, FLThe improper use of elevator flight control during the landing by the pilot in command.NTSB LAX93LA135Accident · Serious injuriesLimited investigationFinal reportDowner Aircraft Industries KR-1 · Prescott, AZThe total loss of engine power for undetermined reasons. A factor in the accident was the lack of a suitable landing area at the time of the power interruption.NTSB LAX93LA133Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-250 · Red Mountain, CAFuel exhaustion due to the pilot's inadequate preflight planning and his failure to refuel the aircraft. Factors in the accident were the pilot's inability to see the terrain due to the dark night conditions and the flight's encounter with instrument…NTSB FTW93LA090Accident · Minor injuriesLimited investigationFinal reportBell 206B · Oklahoma City, OKThe passengers inadvertent control interference. A factor was the pilot's inadequate supervision of the passengerNTSB CHI93LA094Accident · No injuriesLimited investigationFinal reportBeech B90 · Albert Lea, MNAn inadvertent stall due to ice in the pitot/static system.NTSB ANC93LA039Accident · No injuriesLimited investigationFinal reportCessna A185F · Fairbanks, AKThe fuel system selector valve being placed in the off position due to the improper installation of the fuel selector placard by an unqualified person. The snow covered forced landing area was a factor.NTSB MIA93LA072Accident · Minor injuriesLimited investigationFinal reportCessna 182P · Raleigh, MSThe fatigue failure of the no. 1 exhaust valve for undetermined reasons, and the lack of suitable terrain for the forced landing.NTSB LAX93LA132Accident · Serious injuriesLimited investigationFinal reportHughes 369D · Kahului, HIThe pilots failure to maintain an adequate visual lookout for obstructions while performing a low altitude surveillance operation in a mountainous area, and, his failure to select an altitude sufficient to ensure clearance from all potential obstacles.NTSB LAX93LA131Accident · Minor injuriesLimited investigationFinal reportSchicora Osprey 2 · Joshua Tree, CAThe failure of the pilot flying to attain adequate airspeed for lift off and the resulting inadvertent stall mush condition during the initial climb.NTSB FTW93LA089Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Indian Village, LALanding performed short of the runway threshold. Factor was wet grassy terrainNTSB BFO93LA032Accident · 1 fatalLimited investigationFinal reportMorgan Challenger II · Quinton, VAThe pilot's impairment due to a neurological injury and drugs, and his failure to maintain control of the airplane during an approach to land. A factor related to the accident was the gusty wind condition.NTSB CHI93LA092Accident · No injuriesLimited investigationFinal reportCessna 185F · Bridgeport, NEThe pilot's failure to maintain proper runway alignment during the landing roll.NTSB MIA93LA074Accident · No injuriesLimited investigationFinal reportCessna 152 · Punta Gorda, FLThe pilot-in-command's failure to maintain a visual lookout while taxiing into the parking area, resulting in an on-ground collision with a light pole.NTSB MIA93LA071Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Bunnell, FLThe rupture of the oil cooler line at the adel clamp for undetermined reasons, resulting in a loss of engine oil, and a subsequent engine seizure.NTSB LAX93LA129Accident · No injuriesLimited investigationFinal reportCessna 182R · Warner Springs, CAThe pilots decision to attempt flight into known adverse weather conditions.NTSB LAX93LA128Accident · No injuriesLimited investigationFinal reportBellanca 7ECA · Palo Alto, CAThe pilots inadequate compensation for the existing crosswind condition and his resultant loss of directional control.NTSB LAX93LA127Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Bakersfield, CAThe overload failure of the right main landing gear strut attach bolts due to a hard landing. The hard landing was the result of the student misjudging the landing flare, and, the inadequate supervision of the flight by the flight instructor.NTSB FTW93LA091Accident · No injuriesLimited investigationFinal reportCessna 150H · Adkins, TXThe student pilot's failure to maintain clearance while maneuvering. A factor was the student's diverted attention from the open engine inspection doorNTSB CHI93LA093Accident · No injuriesLimited investigationFinal reportPiper PA-23-160 · Cannonball, NDThe blockage of the inlet air filter from snow.NTSB BFO93LA031Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Hudson, NYFailure of the pilot to maintain directional control, which resulted in an advertent ground swerve. The snowbank was a related factor.NTSB ANC93LA036Accident · No injuriesLimited investigationFinal reportMaule M5 · Chena Hot Sprng, AKThe total failure of the landing gear axle as a result of a pre existing fracture in the axle.NTSB ANC93LA035Accident · Serious injuriesLimited investigationFinal reportCessna 206 · Bradley Lake, AKThe pilot in command not removing the frost from the plane's airfoil surfaces before takeoff and not aborting the takeoff when the airplane showed no sign of wanting to fly at the initial rotation point/airspeed. A factor in the accident was the icing…NTSB ANC93FA034Accident · No injuriesField investigationFinal reportCessna 402C · Nome, AKThe pilot in command not removing the ice from the plane's airfoil surfaces before takeoff. The weather condition was a factor.