NTSB investigations
2,248 cases where NTSB found Not determined, general.
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 WHERE c.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '05000000')) 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 WHERE c."mKey" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '05000000')) 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 CEN10CA228Accident · No injuriesData collectionFinal reportPiper PA-32R-300 · Jamestown, NDThe pilot's failure to lower the landing gear, resulting in a gear-up landing.NTSB WPR10LA214Accident · No injuriesLimited investigationFinal reportGrumman Acft ENG Cor-Schweizer G-164A · Madera, CAA loss of engine power for undetermined reasons.NTSB CEN10LA222Accident · Serious injuriesLimited investigationFinal reportCross-Capps Breezy · Livingston, TXA loss of engine power for undetermined reasons.NTSB WPR10LA212Accident · Minor injuriesLimited investigationFinal reportGrumman Acft ENG Cor-Schweizer G-164B · Buckeye, AZA partial loss of engine power during the takeoff roll for undetermined reasons.NTSB ERA10LA238Accident · Serious injuriesLimited investigationFinal reportMcdonnell Douglas Helicopter 369E · Newfane, VTThe pilot's inadvertent encounter with a rope while maneuvering during powerline operations for undetermined reasons.NTSB CEN10LA217Accident · No injuriesLimited investigationFinal reportAir Tractor AT-802A · Alpine, TXA total loss of engine power for undetermined reasons.NTSB CEN10CA214Accident · No injuriesData collectionFinal reportStinson 108-2 · Dexter, MOA loss of engine power for an undetermined reason.NTSB ERA10LA233Accident · 1 fatalLimited investigationFinal reportCessna 172H · Archer, FLThe pilot's failure to maintain adequate airspeed for undetermined reasons while maneuvering in the vicinity of an airport, which resulted in an aerodynamic stall and hard landing.NTSB WPR10LA202Accident · No injuriesLimited investigationFinal reportCostruzioni AeronauticheTecnam P2002 Sierra · Tooele, UTA total loss of engine power for undetermined reasons.NTSB ERA10TA215Accident · No injuriesFinal reportCessna 404 · Ponce, PRA loss of power to the right engine for undetermined reasons.NTSB ERA10LA210Accident · No injuriesLimited investigationFinal reportBeech 35-A33 · Pittsburgh, PAA fire of undetermined origin behind the left instrument panel.NTSB WPR10LA196Accident · No injuriesLimited investigationFinal reportCessna P210N · Leavenworth, WAThe failure of the number two cylinder exhaust and intake valves for undetermined reasons, which resulted in a loss of engine power.NTSB ERA10LA205Accident · 1 fatalLimited investigationFinal reportCupaiole RV-6A · West Palm Beach, FLThe total loss of engine power and the pilot's failure to maintain adequate airspeed while maneuvering, which resulted in an aerodynamic stall and spin. The reason for the loss of power could not be determined.NTSB ERA10LA204Accident · Minor injuriesLimited investigationFinal reportMitsubishi MU-2B-26A · Princeton, KYThe pilot's failure to maintain directional control during landing roll for undetermined reasons, resulting in a runway excursion.NTSB CEN10FA181Accident · 1 fatalField investigationFinal reportCessna 172D · Hillsboro, OHImpact with the runway pavement for unknown reasons.NTSB CEN10LA186Accident · No injuriesLimited investigationFinal reportCessna 182F · Wichita Falls, TXA fire of undetermined origin.NTSB ERA10TA197Accident · Minor injuriesFinal reportCessna 182P · Frederick, MDA loss of engine power for undetermined reasons following a reported severe turbulence encounter.NTSB ERA10FA195Accident · 1 fatalField investigationFinal reportPiper PA46 · Roanoke, VAA malfunction of the flight controls for undetermined reasons.NTSB ERA10LA190Accident · No injuriesLimited investigationFinal reportRobinson R22 · Miami, FLA loss of main rotor rpm for undetermined reasons.NTSB WPR10LA174Accident · No injuriesLimited investigationFinal reportPiper PA30 · Hollister, CAA partial loss of engine power during the initial climb for undetermined reasons.NTSB WPR10LA191Accident · No injuriesLimited investigationFinal reportBeech 58 · Santa Barbara, CAThe landing gear collapsing during the landing roll for undetermined reasons.NTSB ERA10LA184Accident · No injuriesLimited investigationFinal reportCessna 150L · Lake Alfred, FLA loss of engine power during the landing approach for undetermined reasons.NTSB CEN10CA267Accident · No injuriesData collectionFinal reportCessna R172E · Alamogordo, NMAn unknown event that resulted in damage to the airplane's firewall.NTSB CEN10LA168Accident · No injuriesLimited investigationFinal reportCessna 182G · Mount Vernon, MOA loss of engine power due to the failure of the number four connecting rod for undetermined reasons.NTSB CEN10LA165Accident · 1 fatalLimited investigationFinal reportWalsh Philip J SEA REY · Huntsville, ARThe pilot's loss of airplane control for undetermined reasons.NTSB WPR10FA162Accident · 2 fatalField investigationFinal reportNorth American AT6 · Bakersfield, CAThe pilots did not maintain clearance from terrain for undetermined reasons.NTSB WPR10LA160Accident · Serious injuriesLimited investigationFinal reportMigas RV9-A · Twin Falls, IDThe pilot's loss of directional control during landing roll for an undetermined reason.NTSB ERA10IA170Incident · No injuriesIncident investigationFinal reportGulfstream American G-1159A · Farmingdale, NYProgressive cracking from an undetermined initiation source, which resulted in the failure of the No. 4 cabin window outer pane, and the subsequent foreign object ingestion to the right engine.NTSB CEN10WA150Accident · 3 fatalForeign investigationCessna 421 · Tegucigalpa, HondurasThis investigation is under the jurisdiction and control of the Honduran government.NTSB ANC10LA024Accident · No injuriesLimited investigationFinal reportCessna A185E · Ophir, AKThe total loss of engine power for an undetermined reason.NTSB WPR10LA154Accident · No injuriesLimited investigationFinal reportSutton Avid Hauler · Rigby, IDA loss of engine power during takeoff for undetermined reasons.NTSB CEN10WA148Accident · 2 fatalForeign investigationAlon Aircoupe A2-A · Ciborro, Montemor-o-Novo, PortugalThis accident is under the jurisdiction and control of the Portuguese government.NTSB ANC10LA020Accident · Serious injuriesLimited investigationFinal reportMcdonnell Douglas Helicopter 369E · Delta Junction, AKA total loss of engine power in flight for undetermined reasons.NTSB ERA10FA161Accident · 1 fatalField investigationFinal reportCessna T303 · Louisa, VAThe pilot's failure to maintain aircraft control and secure the right engine during a loss of engine power after takeoff. Contributing to the accident was the loss of engine power on the right engine for undetermined reasons.NTSB WPR10LA149Accident · Minor injuriesLimited investigationFinal reportSchafer Starduster SA-300 · North Bend, ORThe complete loss of engine power during cruise for undetermined reasons.NTSB CEN10WA134Accident · 2 fatalForeign investigationCessna 150 · Waldzell, AustriaThis accident is under the jurisdiction and control of the Austrian government.NTSB CEN10FA130Accident · 2 fatalField investigationFinal reportBeech C24R · Bristow, OKThe pilot’s loss of control for undetermined reasons while maneuvering at low altitude.NTSB CEN10LA198Accident · No injuriesLimited investigationFinal reportAmerican Champion 7KCAB · Greeley, COAn in-flight failure of the wing fabric for undetermined reasons.NTSB WPR10LA140Accident · No injuriesLimited investigationFinal reportCessna 210L · Aurora, ORThe failure of the landing gear to properly function for undetermined reasons, resulting in the right main landing gear collapsing during landing. Contributing to the accident was the pilot's failure to follow the emergency gear extension procedure.NTSB ERA10LA146Accident · Minor injuriesLimited investigationFinal reportCessna P210N · Carthage, NCA total loss of engine power during the initial climb after takeoff for undetermined reasons.NTSB CEN10FA124Accident · 2 fatalField investigationFinal reportPiper PA-28-236 · Austin, TXThe pilot’s intentional flight into a building.NTSB CEN10WA121Accident · 2 fatalForeign investigationCessna 550B · Reinhardtsdorf-Schöna, GermanyThis investigation is under the jurisdiction and control of the German Government.NTSB CEN10LA136Accident · No injuriesLimited investigationFinal reportMaule M-5-235C · La Porte, TXA loss of engine power for undetermined reasons.NTSB ERA10FA138Accident · 1 fatalField investigationFinal reportBeech 65 · Lawrenceville, GAThe failure of both engines for undetermined reasons.NTSB ERA10LA128Accident · No injuriesLimited investigationFinal reportCessna 402C · Watertown, NYThe pilot's decision to continue the approach with a known anomaly with the left airspeed indicator. Contributing to the accident was an undetermined malfunction of the left airspeed indicator and the condition of the runway, resulting in decreased braking…NTSB CEN10FA107Accident · 2 fatalField investigationFinal reportCostruzioni Aeronautiche Tecna P2002 · Waxahachie, TXA loss of aircraft control while maneuvering for undetermined reasons.NTSB ANC10FA014Accident · 2 fatalField investigationFinal reportBeech 1900C · Sand Point, AKAn in-flight loss of control for an undetermined reason, which resulted in an uncontrolled descent.NTSB CEN10MA088Accident · 2 fatalMajor investigationFinal reportGates Learjet 35A · Prospect Heights, ILA loss of control for undetermined reasons.NTSB CEN10CA091Accident · Minor injuriesData collectionFinal reportGrumman American AA-5B · Santa Fe, NMThe restricted elevator control movement for undetermined reasons.NTSB CEN10LA080Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Alexandria, LAA loss of engine power for undetermined reasons.