NTSB investigations
180,598 investigations by the National Transportation Safety Board since 1962: 174,578 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 ANC26LA042Accident · No injuriesClass 4 · LimitedInvestigation openPiper PA-14 · Nenana, AKNTSB WPR26LA196Accident · Serious injuriesClass 4 · LimitedFinal reportDiamond DA40 · Wells, NVThe pilot’s inability to maintain climb performance and clearance from mountainous terrain due to a downdraft.NTSB WPR26FA189Accident · 2 fatalClass 3 · FieldPreliminary reportPiper PA-32-300 · Empire, NVOn May 17, 2026, about 0738 PDT, a Piper PA-32-300, N8502N, was substantially damaged when it was involved in an accident near Empire, Nevada. The pilot and passenger sustained fatal injuries. The airplane was operated as a Title 14 Code of Federal…NTSB GAA26WA191Accident · No injuriesClass 5 · ForeignCessna 188 · De Los TsáChilas, EcuadorNTSB DCA26WA216IncidentClass 5 · ForeignBoeing 737-8 · Liberia, Costa RicaNTSB WPR26LA192Accident · No injuriesClass 4 · LimitedFinal reportCirrus Design SR22T · Vernal, UTThe pilot's failure to maintain control during the landing flare with a gusting crosswind.NTSB GAA26WA248Accident · 2 fatalClass 5 · ForeignNorth American T28 · Limburghof, GermanyNTSB GAA26WA192Accident · No injuriesClass 5 · ForeignSonex Sonex · Lincolnshire, United KingdomNTSB DCA26WA209Incident · No injuriesClass 5 · ForeignAirbus 220 · Split, CroatiaNTSB CEN26LA191Accident · Minor injuriesClass 3 · LimitedPreliminary reportVertical Hummingbird · Lee's Summit, MOOn May 16, 2026, about 0950 central daylight time, a Vertical Aviation Technologies 300L Hummingbird helicopter, N284ST, was substantially damaged when it was involved in an accident near Lee’s Summit, Missouri. One passenger sustained minor injuries. The…NTSB CEN26LA190Accident · 1 fatalClass 3 · LimitedPreliminary reportDowner 14-19-3 · Forney, TXOn May 16, 2026, about 0010 central daylight time, a Downer 14-19-3 airplane, N7NL, was substantially damaged when it was involved in an accident near Forney, Texas. The pilot and one passenger sustained minor injuries. A second passenger initially survived…NTSB ANC26LA041Accident · No injuriesClass 4 · LimitedInvestigation openPiper PA-11 · Susitna, AKNTSB WPR26LA191Accident · No injuriesClass 3 · LimitedPreliminary reportBigham Jack L Marquart M 5 Charger · Tucson, AZOn May 15, 2026, about 1500 mountain standard time, an experimental amateur built Marquart M5 Charger was substantially damaged when it was involved in an accident near Tucson, Arizona. The pilot was not injured. The airplane was operated as a Title 14 Code…NTSB WPR26LA190Accident · No injuriesClass 3 · LimitedPreliminary reportPiper PA-28-140 · Chandler, AZOn May 14, 2026, at 2043 mountain standard time, a Piper PA-28, N8714N, was substantially damaged when it was involved in an accident near Chandler, Arizona. The pilot sustained minor injuries. The airplane was operated as a Title 14 Code of Federal…NTSB ERA26LA211Accident · No injuriesClass 3 · LimitedPreliminary reportPatsch Thorp T-18 · Hendersonville, NCOn May 15, 2026, about 1853 eastern daylight time, an experimental amateur-built Thorp T-18, N2KP, was substantially damaged when it was involved in an accident near Hendersonville, North Carolina. The commercial pilot was not injured. The airplane was…NTSB ERA26LA210Accident · No injuriesClass 4 · LimitedFinal reportJohn Bradley Vans RV-7 · Athens, GAContamination of the left wheel brake system with debris, which resulted in a loss of directional control during takeoff.NTSB DCA26WA212AccidentClass 3 · ForeignBoeing 737 · Muscat, OmanNTSB CEN26LA189Accident · No injuriesClass 4 · LimitedFinal reportMooney M20J · Morris, ILThe pilot’s inadequate fuel management, which resulted in a loss of engine power due to fuel starvation.NTSB WPR26LA197Accident · Serious injuriesClass 3 · LimitedPreliminary reportMooney M20J · Lake Havasu City, AZOn May 14, 2026, at 1523, a Mooney M20J, N4665H, was substantially damaged when it was involved in an accident near Lake Havasu City, Arizona. The pilot and two passengers sustained serious injuries. The airplane was operated under Title 14 Code of Federal…NTSB WPR26LA193Accident · No injuriesClass 4 · LimitedFinal reportBellanca 7ACA · Pacific City, ORThe pilot’s loss of directional control during a precautionary landing following a partial reduction in engine rpm.NTSB WPR26LA188Accident · Minor injuriesClass 4 · LimitedFinal reportMcdonnell Douglas Helicopter 500 · Twin Falls, IDThe pilot’s failure to maintain control while hovering in gusty wind conditions, resulting in the helicopter rolling onto its side.NTSB WPR26FA186Accident · 4 fatalClass 3 · FieldPreliminary reportBeech C90 · Lincoln, NMOn May 14, 2026, at 0015 mountain daylight time, a Beech C90, N249CP, was destroyed when it was involved in an accident near Lincoln, New Mexico. Both pilots and passengers sustained fatal injuries. The airplane was operated by Generation Jets under the…NTSB GAA26WA197Accident · No injuriesClass 5 · ForeignCessna FRA150 · Retford, United KingdomNTSB ERA26FA208Accident · 2 fatalClass 3 · FieldPreliminary reportPiper PA-28-180 · Akron, OHOn May 14, 2026, at 1545 eastern daylight time, a Piper PA-28-180, N7188W, was destroyed when it was involved in an accident near Akron, Ohio. The flight instructor and student pilot were fatally injured. The airplane was operated as a Title 14 Code of…NTSB DCA26WA202Incident · No injuriesClass 5 · ForeignBoeing 747-428F · Ciudad de la Costa, UruguayNTSB WPR26LA194Accident · Minor injuriesClass 4 · LimitedFinal reportAutogyro Cavalon · Palo Alto, CAThe pilot’s failure to maintain directional control during the landing roll, in gusting crosswind conditions.NTSB WPR26LA185Accident · No injuriesClass 3 · LimitedPreliminary reportCraig Ellison Bearhawk Four · Sandpoint, IDOn May 12, 2026, about 1940 Pacific daylight time (PDT), an experimental amateur-built Bearhawk Four airplane, N953CN, was substantially damaged when it was involved in an accident at Olmstead Sky Ranch in Sandpoint, Idaho. The pilot was uninjured, and the…NTSB CEN26LA205Accident · No injuriesClass 4 · LimitedFinal reportVans RV4 · Conroe, TXThe pilot’s failure to properly latch the canopy before flight, which led to the canopy opening shortly after takeoff.NTSB CEN26LA188Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-34-220T · Corpus Christi, TXThe pilot's failure to extend the main landing gear prior to landing, which resulted in a gear up landing. Contributing to the accident was the pilot’s distraction during the approach.NTSB CEN26LA187Accident · No injuriesClass 3 · LimitedPreliminary reportCessna 172S · Denton, TXOn May 13, 2026, about 1815 central daylight time, a Cessna 172S, N2134M, sustained substantial damage when it was involved in an accident near Denton, Texas. The pilot was not injured. The airplane was operated as a Title 14 Code of Federal Regulations Part…NTSB CEN26LA186Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28R-201 · West Chicago, ILThe pilot’s improper decision to attempt an intersection takeoff and delay to abort the takeoff which resulted in a subsequent runway excursion.NTSB CEN26LA185Accident · No injuriesClass 3 · LimitedFinal reportBell 407 · Dallas, TXThe pilot’s failure to maintain situational awareness and clearance from the helipad surveillance camera during liftoff.NTSB WPR26LA187Accident · No injuriesClass 4 · LimitedFinal reportCirrus Design SR20 · Sedona, AZThe pilot’s inability to maintain directional control due to a plastic foreign object jammed in the rudder pedals, while landing with a gusting left crosswind.NTSB WPR26LA183Accident · No injuriesClass 3 · LimitedPreliminary reportStinson 108-3 · Quilcene, WAOn May 12, 2026, at about 1049 Pacific daylight time, a Stinson 108-3 airplane, N588C, was substantially damaged when it was involved in an accident near Quilcene, Washington. The pilot was uninjured. The airplane was operated as a Title 14 Code of Federal…NTSB WPR26LA182Accident · No injuriesClass 4 · LimitedFinal reportAmerican AA-5 · Jurupa Valley, CAThe pilot’s decision to land at night on a runway without illuminated runway lights. Contributing to the accident was the pilot’s failure to review NOTAMs for a nightly airport closure.NTSB GAA26WA189Accident · Minor injuriesClass 3 · ForeignBeech 300 · Atlantic Ocean, BahamasNTSB ERA26LA207Accident · 1 fatalClass 4 · LimitedFinal reportI.C.A.-Brasov IS-28B2 · Scotts Fork, VAThe photographer’s failure to remain clear of an active taxiway.NTSB ERA26FA205Accident · 1 fatalClass 3 · FieldPreliminary reportCessna A185F · Avon, MEOn May 12, 2026, about 1058 eastern daylight time, a Cessna A185F airplane, N61368, was substantially damaged when it was involved in an accident near Avon, Maine. The pilot was fatally injured. The airplane was owned by the state of Maine and operated as a…NTSB DCA26WA199Incident · No injuriesClass 5 · ForeignBoeing 747 · Karachi, PakistanNTSB DCA26LA203Accident · Serious injuriesClass 4 · LimitedInvestigation openShield Ai V-BAT · Gulf of America (Gulf of Mexico)NTSB CEN26FA184Accident · 1 fatalClass 3 · FieldPreliminary reportNorth American F-51D · Mound, LAOn May 12, 2026, at 1519 central daylight time, a North American F-51D airplane, N251CS, was destroyed when it was involved in an accident at the Vicksburg Tallulah Regional Airport (TVR), Mound, Louisiana. The pilot was fatally injured. The airplane was…NTSB WPR26LA184Accident · No injuriesClass 4 · LimitedFinal reportVans RV-6A · Kooskia, IDThe pilot’s collision with a hole in the runway surface during the landing roll, which resulted in a nose over.NTSB GAA26WA208Incident · No injuriesClass 5 · ForeignBeech 35 · Griffith, AustraliaNTSB DCA26WA233Incident · No injuriesClass 5 · ForeignBoeing 737 · Gwaska, NigeriaNTSB CEN26LA183Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 182P · Bennett, COThe pilot’s improper flare during landing that resulted in a hard landing.NTSB WPR26LA180Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 172 · Marysvale, UTThe pilot's failure to maintain clearance from trees while maneuvering in mountainous terrain prior to encountering a downdraft.NTSB WPR26LA179Accident · No injuriesClass 4 · LimitedFinal reportCessna A150L · Superior, AZThe pilot's failure to retract the flaps during takeoff following a touch-and-go landing, which resulted in degraded climb performance and an impact with an object during an off-field landing.NTSB GAA26WA298Accident · No injuriesClass 5 · ForeignScheibe SF25 · Speyer, GermanyNTSB GAA26WA193Accident · 4 fatalClass 5 · ForeignCessna 210 · Hammerstein, NamibiaNTSB ERA26LA206Accident · No injuriesClass 3 · LimitedPreliminary reportCessna 750 · Fort Myers, FLOn May 9, 2026, at 1014 eastern daylight time, a Cessna 750 airplane, N119RM, was substantially damaged when it was involved in an accident near Fort Myers, Florida. The captain and first officer were not injured. The airplane was operated as a Title 14 Code…