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 SEA99LA055Accident · No injuriesLimited investigationFinal reportPiper J-3 · Vancouver, WAThe failure of the pilot of the other aircraft to maintain clearance from the pilot's stationary aircraft.NTSB SEA99LA054Accident · 1 fatalLimited investigationFinal reportWells Baby Lakes · Monroe, WAThe pilot's failure to maintain aircraft control. A factor was attempting to fly the airplane outside of its weight and balance limits.NTSB NYC99FA096Accident · 1 fatalField investigationFinal reportSellors Searey · Selby Beach, MDThe pilot's failure to maintain aircraft control during the landing sequence, which resulted in the airplane contacting the water in a nose low attitude.NTSB MIA99LA138Accident · No injuriesLimited investigationFinal reportPiper PA-24-180 · Fernandina Bch, FLThe failure of the pilot to use the printed checklist which resulted in the gear-up landing. A factor associated with the accident was the intermittent failure of the gear warning horn.NTSB LAX99FA160Accident · 1 fatalField investigationFinal reportCessna 150G · Gorman, CAThe pilot's intentional flight into adverse weather conditions beneath a low ceiling in mountainous terrain.NTSB FTW99FA121Accident · 1 fatalField investigationFinal reportCessna 182G · Blanco, TXThe pilot's continued flight into adverse weather conditions and his failure to maintain clearance with terrain. Factors were, the low cloud and drizzle weather conditions, and the dark night light conditions.NTSB ANC99LA054Accident · No injuriesLimited investigationFinal reportPiper PA-18 · King Salmon, AKThe pilot's failure to maintain directional control. A factor associated with the accident was an inadvertent ground loop.NTSB NYC99LA095Accident · No injuriesLimited investigationFinal reportCessna 152 · Wall, NJThe pilot in command's improper preflight preparation, which resulted in fuel exhaustion and subsequent loss of engine power.NTSB MIA99LA137Accident · Serious injuriesLimited investigationFinal reportBeech A36 · Courtland, ALThe failure of maintenance personnel from Signature Flight Support to assure that a cotter pin was installed at the air throttle assembly lever following installation of the overhauled fuel control valve onto the overhauled engine. This resulted in the…NTSB LAX99LA159Accident · No injuriesLimited investigationFinal reportCessna R182 · San Luis Obispo, CAThe inadequate preflight inspection of the aircraft by the pilot-in-command which resulted in a loss of engine power due to water contamination in the fuel system. A factor in the accident was an improper maintenance alteration which disabled a fuel sump…NTSB FTW99RA122Accident · 3 fatalForeign investigationKawasaki BK-117B-1 · Keelung, TaiwanNTSB MIA99LA136Accident · Minor injuriesLimited investigationFinal reportCessna 402B · Fort Lauderdale, FLA loss of engine power due to fuel exhaustion and the pilot in command's failure to ensure that the aircraft had adequate fuel to complete the flight.NTSB MIA99LA135Accident · Serious injuriesLimited investigationFinal reportCessna 150M · S. Rockledge, FLA total loss of engine power while in cruise flight due to the pilot's failure to use carburetor heat during carburetor icing conditions and the subsequent emergency landing to unsuitable terrain and collision with a tree.NTSB MIA99LA134Accident · Serious injuriesLimited investigationFinal reportDurrwachter Wittman Tailwind · Dover, TNA loss of engine power for undetermined reasonsNTSB MIA99LA133Accident · No injuriesLimited investigationFinal reportBell 47G-3B1 · Thomastown, MSAn in-flight loss of control caused by the main rotor severing the tail rotor drive shaft as a result of the pilot's cyclic pull-up into a tailwind for his second approach and landing. The loss of the tail rotor caused an uncontrollable descent and tree…NTSB LAX99LA157Accident · No injuriesLimited investigationFinal reportSchweizer G-164B · Marysville, CAA loss of engine power due to a leaking surge bleed valve which induced compressor stalls within the engine.NTSB FTW99LA118Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Cleburne, TXThe pilot's improper flare which resulted in a hard landing and his improper recovery procedures from a bounced landing.NTSB ATL99LA073Accident · No injuriesLimited investigationFinal reportCessna 140A · Dallas, GAThe pilot's selection of unsuitable terrain/landing area for a short field landing, and his delay in executing a go-around.NTSB ATL99FA072Accident · 2 fatalField investigationFinal reportBeech T-34A · Rydal, GAFracture of the wing spar as a result of fatigue cracking that occurred over an unknown number of flights and flight hours with a wing loading spectrum not anticipated during design of the airplane. This report was modified on November 2, 2005.NTSB ANC99LA051Accident · No injuriesLimited investigationFinal reportBritten-Norman BN-2B-21 · Kongiganak, AKThe deep, water filled hole in the runway.NTSB SEA99LA053Accident · No injuriesLimited investigationFinal reportBeech 35-C33 · Hillsboro, ORA landing gear collapse for undetermined reasons.NTSB MIA99LA145Accident · No injuriesLimited investigationFinal reportBeech E33 · Orlando, FLthe pilot's failure to maintain control of the airplane during takeoff, resulting in the airplane departing the runway, and subsequently impacting with an airport sign.NTSB LAX99LA158Accident · No injuriesLimited investigationFinal reportNorth American AT-6D · Hollister, CAThe pilot's inadequate compensation for the crosswind condition, and his failure to maintain directional control during landing.NTSB LAX99LA156Accident · No injuriesLimited investigationFinal reportBeech A23-24 · Yerington, NVThe partial loss of engine power due to the pilot's failure to properly lean the engine for the high density altitude takeoff.NTSB LAX99LA155Accident · No injuriesLimited investigationFinal reportCessna 150H · Yuba City, CAA total loss of engine power resulting from the fatigue failure of a cylinder's exhaust valve. A contributing factor was the uneven terrain at the forced landing site. The reason for the fatigue could not be determined.NTSB LAX99LA154Accident · Serious injuriesLimited investigationFinal reportCessna A150L · Lake Mary, AZThe pilot's intentional buzzing and misjudged altitude/clearance with the nearby rising terrain. Contributing factors were the high density, the airplane's high gross weight, and the pilot's improper in-flight decisions.NTSB IAD99LA039Accident · No injuriesLimited investigationFinal reportCessna 152 · Fairfield, NJwas the pilot's inadequate compensation for winds and his improper recovery from a bounced landing.NTSB FTW99LA117Accident · No injuriesLimited investigationFinal reportCessna 170B · Fayetteville, ARThe pilot's failure to obtain the proper climb rate resulting in an inadvertent stall. Factors were the rising terrain and the variable winds.NTSB ANC99LA048Accident · No injuriesLimited investigationFinal reportElam RAF 2000-GTX · Palmer, AKThe pilot's inadequate compensation for wind conditions. A factor associated with the accident was a downdraft.NTSB NYC99LA094Accident · No injuriesLimited investigationFinal reportCessna 172M · Lumberton, NJThe pilot's misjudgment of altitude and distance which resulted in a runway overrun.NTSB NYC99LA093Accident · 1 fatalLimited investigationFinal reportMooney M20E · Brooksville, KYContaminated fuel which resulted in the forced landing, and a heart attack from an adrenaline rush that interacted with preexisting coronary disease which resulted in the pilot's death.NTSB NYC99FA091Accident · Serious injuriesField investigationFinal reportRaytheon Corporate Jets BE-400A · Beckley, WVThe pilot-in-command misjudged his altitude and airspeed which resulted in an overrun. Contributing to the accident were the pilot's lack of total flight experience in make and model, the pilot's reliance on the airplane's optional thrust reverser system and…NTSB MIA99LA131Accident · 1 fatalLimited investigationFinal reportPiper J-3C · Jackson, MSThe failure of the airshow aerial performer to maintain a grip on the airplane's externally mounted rope ladder for unknown reasons and his failure to install and use a safety line resulting in his fall to earth. A factor in the accident was the sudden…NTSB LAX99LA153Accident · Serious injuriesLimited investigationFinal reportVentura Rans S-12 · El Cajon, CAEngine power loss due to an interruption of fuel to or within a carburetor, and the resultant overheating of its associated cylinder. The reason for the fuel flow interruption could not be determined.NTSB SEA99LA052Accident · No injuriesLimited investigationFinal reportCessna 177 · Auburn, WAThe pilot's improper flare. Contributing factors were gusty, crosswind conditions, and the student's minimal overall experience.NTSB NYC99LA090Accident · No injuriesLimited investigationFinal reportRobinson R-22 · Port Jefferson, NYthe lack of supervision by the flight instructor which resulted in a low rotor condition and subsequent hard landing.NTSB LAX99LA181Accident · No injuriesLimited investigationFinal reportPiper PA-31-310 · La Verne, CAThe in-flight separation of the right engine cowling due to the operator's inadequate maintenance quality control procedures and the pilot's inadequate preflight inspection.NTSB LAX99LA152Accident · No injuriesLimited investigationFinal reportBoeing A75N1 · Casa Grande, AZThe pilot's decision to continue flight into a known adverse weather condition, and, his failure to adequately compensate for the crosswind gust condition and maintain directional control during the landing rollout.NTSB LAX99LA149Accident · Minor injuriesLimited investigationFinal reportPiper PA-31 · Pacific Ocean (Pacific Ocean)An undetermined system malfunction in the right engine, which led to an increase in fuel usage beyond the pilot's planned fuel consumption rate and eventual fuel supply exhaustion.NTSB LAX99LA148Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Van Nuys, CAThe check pilot's inadequate supervision of the flight and his failure to ensure that an adequate altitude margin existed during the maneuver.NTSB LAX99FA150Accident · 2 fatalField investigationFinal reportBeech 36 · San Diego, CAThe pilot's failure to maintain the proper glidepath during an ILS approach. A factor in the accident was the pilot's disregard for the weather reports, which showed the airport as being below landing minimums.NTSB DCA99RA056Accident · 3 fatalForeign investigationMcDonnell Douglas MD-11 · Shanghai, ChinaNTSB ANC99LA053Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Anchorage, AKThe pilot's inadequate compensation for crosswind conditions. Factors associated with the accident were a crosswind, and an inadvertent ground loop.NTSB SEA99TA051Accident · Minor injuriesFinal reportI.C.A. Brasov IS-28B2 · North Plains, ORThe second pilot did not maintain clearance from power lines. The pilot-in-command did not adequately supervise the second pilot, and the second pilot's diverted attention and lack of familiarity with the geographic area were factors.NTSB MIA99LA130Accident · Minor injuriesLimited investigationFinal reportZemp Avid Catalina · Sebring, FLThe in-flight separation of one of the propeller blade's and one of the engine's exhaust pipes causing the engine to vibrate until it stopped running. A related factor was the unsuitable terrain for the forced landing.NTSB MIA99LA128Accident · No injuriesLimited investigationFinal reportPiper PA-44-180 · Vero Beach, FLThe improper return to service of a propeller hub by a propeller overhaul company which according to manufacturer's procedures should have been retired due to damage to propeller blades from sudden stoppage. This resulted in undetected fatigue propagation…NTSB MIA99LA127Accident · No injuriesLimited investigationFinal reportLake LA-4-200 · Pensacola, FLThe pilot's inability to maintain directional control due to failure of the main landing gear, and partial electrical system failure for undetermined reasons.NTSB MIA99FA126Accident · Minor injuriesField investigationFinal reportBeech E-55 · Lakeland, FLFailure of the pilot of the other aircraft to maintain a visual lookout and visual separation while on approach for landing. This resulted in a midair collision with another airplane and subsequent in-flight collision with the runway.NTSB LAX99RA151Accident · 4 fatalForeign investigationBell 206B · 60 N. Jakarta, IndonesiaNTSB DCA99RA057Accident · No injuriesForeign investigationLearjet 55 · Finland