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 ERA10LA004Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · Whiteville, NCThe pilot's improper flare and subsequent hard landing during an intentional gear-up landing following multiple mechanical malfunctions. Also causal to the accident was an inoperative landing gear emergency-down valve which had blockage for undetermined…NTSB ERA10CA003Accident · No injuriesData collectionFinal reportMalone Henry O Howland · Gloucester, VAA loss of engine power due to fuel exhaustion as a result of the pilot's inadequate pre-flight planning .NTSB ERA10CA002Accident · No injuriesData collectionFinal reportPiper PA-24-260 · Highgate, VTThe pilot’s improper fuel management which resulted in loss of engine power due to fuel starvation.NTSB CEN10WA009Accident · 2 fatalForeign investigationBeech A36 · Guanajuato, MexicoOn October 3, 2009, approximately 1030 central daylight time a Beech A36TC, XB-CGU, was substantially damaged upon impact with terrain near Guanajuato, Mexico. Visual meteorological conditions prevailed at the time of the accident. The pilot and one passenger…NTSB CEN10TA006Accident · No injuriesFinal reportBeech E18S · Jones Creek, TXThe pilot's failure to see and avoid the radio tower.NTSB CEN10LA008Accident · Minor injuriesLimited investigationFinal reportCrawford Alan R Glasair II · San Saba, TXA partial loss of engine power for undetermined reasons.NTSB CEN10LA002Accident · Serious injuriesLimited investigationFinal reportPiper J3C-65 · Rosemount, MNThe pilot's delayed use of carburetor heat while operating in conditions conducive to carburetor icing.NTSB WPR10LA001Accident · Serious injuriesLimited investigationFinal reportCessna 180 · Mitchell, ORThe pilot’s lack of understanding of the airplane’s fuel system, which resulted in a loss of engine power due to fuel exhaustion.NTSB ERA10CA001Accident · No injuriesData collectionFinal reportBell 47D1 · Dorrance, PAA total loss of engine power due to fuel exhaustion for undetermined reasons.NTSB ENG09RA019Incident · No injuriesForeign investigationBoeing 737 · Kuching, MalaysiaOn October 2, 2009, about 0818 Coordinated Universal Time (UTC) a Malaysia Airlines, Boeing 737-400 airplane, registration 9M-MMR, suffered a collapsed left main landing gear during pushback from the gate at Kuching International Airport, Kuching, Sarawak,…NTSB CEN10WA003Accident · 1 fatalForeign investigationCessna F172N · Sulzberg, GermanyUnder the jurisdiction and control of the German government.NTSB CEN10LA005Accident · Minor injuriesLimited investigationFinal reportBeech A36 · Refugio, TXA total loss of engine power due to fuel starvation as a result of the pilot's improper fuel management. Contributing to the accident was the pilot's failure to follow the correct engine restart checklist.NTSB ERA10WA012Accident · 3 fatalForeign investigationAerospatiale AS350 · Cusco, PeruOn October 1, 2009, about 2205 UTC, a Eurocopter AS350-B3, Peruvian registration OB-1911-P, operated by Coyotair S.A.C., was destroyed following an impact with terrain near Cusco, Peru. The helicopter impacted against a hill side at approximately 11,700 feet…NTSB ERA10LA009Accident · No injuriesLimited investigationFinal reportButler Aerostar · Brooksville, FLThe collapse of the nose landing gear during landing rollout for undetermined reasons.NTSB CEN10LA001Accident · Serious injuriesLimited investigationFinal reportDusenberry Mark J 1905 Wright Flyer · Dayton, OHThe pilot's failure to maintain control of the airplane during the flight, which resulted in an aerodynamic stall.NTSB CEN09LA611Accident · 1 fatalLimited investigationFinal reportMckenna James E AVID-CATAL · Inks Lake, TXThe pilot’s decision to take off with a known airframe deficiency.NTSB CEN09FA610Accident · 1 fatalField investigationFinal reportMooney M20M · Albany, INThe incapacitation of the pilot during high-altitude cruise flight for undetermined reasons.NTSB WPR09CA474Accident · No injuriesData collectionFinal reportCessna T182T · Granite Falls, WALanding in rugged terrain for undetermined reasons.NTSB ENG10WA002Incident · No injuriesForeign investigationBoeing 737 · Birgi, Trapani, Sicily, Italy, ItalyOn September 29, 2009 at 8:15 UTC, a Ryanair Boeing 737-800, registration number EI-DWD encountered and struck a flock of birds during takeoff from runway 31L at Trapani Birgi Airport (LICT), Sicily, Italy. The engines ingested some birds causing damage to…NTSB CEN09CA608Accident · No injuriesData collectionFinal reportPiper J3C-65 · Spearfish, SDThe pilot's failure to maintain directional control during the takeoff roll.NTSB ANC09LA110Accident · No injuriesLimited investigationFinal reportHughes 369A (OH-6A) · Palmer, AKA partial loss of engine power after take off for an undetermined reason, which resulted in a hard landing.NTSB WPR09LA472Accident · No injuriesLimited investigationFinal reportAmerican Legend AL3 · Fresno, CAThe pilot's failure to maintain directional control during the landing roll.NTSB WPR09LA471Accident · Minor injuriesLimited investigationFinal reportArrow Falcon Exporters OH-58A+ · Myrtle Creek, ORA partial loss of engine power during takeoff for undetermined reasons.NTSB WPR09CA470Accident · Minor injuriesData collectionFinal reportRobinson Helicopter R44 II · Mt Charleston, NVThe pilot's failure to maintain aircraft control and terrain clearance while maneuvering at a low altitude above high terrain. Contributing to the accident was a downdraft and high density altitude.NTSB WPR09CA468Accident · No injuriesData collectionFinal reportCessna 195 · Kingman, AZFailure of the right landing gear wheel attachment bolts.NTSB WPR09CA473Accident · No injuriesData collectionFinal reportAviat A-1B · Toledo, WAThe pilot's failure to maintain clearance from a tree while taxiing. Contributing to the accident was the pilot's distracted attention.NTSB WPR09CA467Accident · No injuriesData collectionFinal reportBeech 35-C33 · Tillamook, ORA loss of engine power due to fuel exhaustion as a result of the pilot's failure to visually verify that sufficient fuel was on board prior to flight. Contributing to the accident was a malfunctioning fuel gage.NTSB ERA09LA547Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Glen St. Mary, FLThe pilot's failure to maintain control of the airplane during the landing.NTSB ERA09LA538Accident · No injuriesLimited investigationFinal reportBombardier CL-600-2B16 · Vineyard Haven, MAThe pilot's improper flare while landing in gusting wind, which resulted in a hard landing.NTSB ERA09CA541Accident · No injuriesData collectionFinal reportCessna 172P · Pensacola, FLThe pilot's inability to maintain control during landing due to the separation of the nose landing gear upper scissor from the nose gear assembly. Contributing to the accident was the inadequate visual examination performed during the annual inspection.NTSB ERA09CA539Accident · Minor injuriesData collectionFinal reportCessna 172 · Factoryville, PAThe flight instructor's delayed decision to take control of the airplane and execute a missed approach. Contributing to the accident was the lack of communication between the certificated flight instructor and the pilot receiving instruction.NTSB ANC09CA107Accident · No injuriesData collectionFinal reportPiper PA-20 · Fairbanks, AKThe student pilot's decision to attempt an off-airport landing and his failure to maintain directional control during the landing roll.NTSB WPR09CA469Accident · No injuriesData collectionFinal reportCessna 182 · Parowan, UTThe pilot's improper flare and recovery from a bounced landing.NTSB WPR09CA466Accident · Minor injuriesData collectionFinal reportBeech A23-19 · Tehachapi, CAThe pilot's failure to attain an established approach path while on final approach resulting in an improper flare and bounced landing.NTSB ERA09FA537Accident · 3 fatalField investigationFinal reportEurocopter AS-350 · Georgetown, SCThe pilot’s decision to continue the visual flight rules flight into an area of instrument meteorological conditions, which resulted in the pilot’s spatial disorientation and a loss of control of the helicopter. Contributing to the accident was the inadequate…NTSB ERA09CA542Accident · Minor injuriesData collectionFinal reportSchweizer 269C · Quarryville, PAAn untrained bystander's attempt to marshal the helicopter, which resulted in the helicopter's inadvertent encounter with an object.NTSB DCA10WA027Incident · No injuriesForeign investigationBoeing 777 · St. Kitts, St. Kitts & NevisOn September 26, 2009, a British Airways B777, registration GVIIR, took off from the incorrect runway intersection at St. Kitts airport, using all all available pavement. There were no injuries or damage. The AAIB-UK is investigating.NTSB CEN09CA609Accident · No injuriesData collectionFinal reportAeronca 11AC · Augusta, KSThe pilot's failure to maintain directional control while landing with a quartering tailwind.NTSB ANC09CA109Accident · No injuriesData collectionFinal reportShort Bros. & Harland SC7 Series · Skwentna, AKThe pilot's failure to maintain directional control while landing on a rough, soft, and narrow airstrip.NTSB WPR09FA464Accident · No injuriesField investigationFinal reportEurocopter AS 350 B3 · Tucson, AZThe loss of directional control for undetermined reasons.NTSB WPR09CA465Accident · No injuriesData collectionFinal reportCessna 195A · Upland, CAThe pilot's failure to maintain directional control of the airplane during the takeoff roll.NTSB ERA09WA546Accident · 2 fatalForeign investigationPiper PA18 · Barbones, Ecuador, EcuadorOn September 25, 2009, about 1330 central standard time, a Piper PA-18-150, Ecuadorian registration HC-AHD, registered to and operated by FumiPalma S.A., crashed following a loss of engine power, while on an approach for landing at the Pista Bardones, El Oro,…NTSB ERA09LA544Accident · No injuriesLimited investigationFinal reportCelier Xenon RST · Mount Pleasant, SCThe gyroplane's inadequate climb performance for undetermined reasons.NTSB ERA09CA545Accident · No injuriesData collectionFinal reportKermit Weeks Quicksilver · Polk City, FLThe pilot’s failure to adequately inspect the landing gear floats for water prior to takeoff.NTSB DCA09WA078Accident · No injuriesForeign investigationRobinson R44 · Annerdale, South AfricaOn September 25, 2009, about 2100 UTC, ZS-RMN, a Robinson R44, operated by National Airways Corporation, landed hard during an autorative landing near Annerdale, South Africa. The pilot and passenger were not injured. The helicopter was substantially damaged.…NTSB CEN09LA605Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-260 · Troy, MIA loss of engine power during initial climb due to fuel starvation as a result of the pilot's selection of an empty or nearly empty main tank for takeoff.NTSB ANC09CA108Accident · No injuriesData collectionFinal reportBellanca 7GCBC · Fairbanks, AKThe pilot's failure to maintain control of the airplane during the landing roll at an off-airport site.NTSB WPR09LA463Accident · 1 fatalLimited investigationFinal reportFrazier Tangent · Nampa, IDThe pilot's failure to maintain pitch control of the airplane.NTSB WPR09CA477Accident · No injuriesData collectionFinal reportCessna 182 · Enterprise, ORThe pilot's failure to stop his airplane before it departed the end of the unimproved remote airstrip.NTSB ERA09LA536Accident · 1 fatalLimited investigationFinal reportDuke Paul Challenger II · Lumberton, MSThe non-certificated pilot’s failure to maintain clearance from trees during a go-around procedure for unknown reasons.