NTSB investigations, MD
16 cases where NTSB found Not determined, general.
Cases per year
| 2008 | 1 |
|---|---|
| 2009 | 1 |
| 2010 | 1 |
| 2011 | 2 |
| 2013 | 1 |
| 2014 | 1 |
| 2015 | 2 |
| 2017 | 2 |
| 2018 | 1 |
| 2019 | 1 |
| 2021 | 1 |
| 2022 | 1 |
| 2023 | 1 |
Where
Open the mapLatest cases
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.\"eventStateOrRegion\" = 'MD' AND c.\"eventCountry\" = 'USA'
AND 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."eventStateOrRegion" = 'MD' AND c."eventCountry" = 'USA' AND 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 ERA23LA349Accident · No injuriesClass 3 · LimitedFinal reportCessna A185F · Leonardtown, MDA loss of engine power during an approach to landing for undetermined reasons.NTSB ERA23LA093Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-28-151 · Annapolis, MDA reported partial loss of engine power for undetermined reasons.NTSB ERA21LA267Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA-28-161 · Easton, MDA total loss of engine power for reasons that could not be determined.NTSB ERA19LA160Accident · No injuriesLimited investigationFinal reportPiper PA28R · Easton, MDThe loss of engine power for reasons that could not be determined because postaccident engine examination and testing revealed no preimpact mechanical malfunctions or failures that would have precluded normal operation.NTSB ERA18LA094Accident · 2 fatalLimited investigationFinal reportCessna 172 · Ocean City, MDThe pilot's flight in dark night visual meteorological conditions, which resulted in an impact with water for reasons that could not be determined based on the available information.NTSB ERA18LA021Accident · No injuriesClass 2 · LimitedFinal reportSocata TB200 · Annapolis, MDA loss of engine power for undetermined reasons after the disconnection of the propeller governor control due to inadequate securenment during maintenance.NTSB ERA17LA100Accident · Serious injuriesLimited investigationFinal reportPiper PA32R · Friendly, MDA total loss of engine power during initial climb for reasons that could not be determined because examination of the wreckage revealed no mechanical malfunctions or failures that would have precluded normal operation.NTSB ERA16LA046Accident · No injuriesLimited investigationFinal reportMooney M20 · Fort Meade, MDA partial loss of engine power for reasons that could not be determined because postaccident examination of the engine revealed no mechanical malfunctions or failures that would have precluded normal operation.NTSB ERA15LA179Accident · No injuriesLimited investigationFinal reportBell 206B · Taylors Island, MDA partial loss of engine power during cruise flight for reasons that could not be determined because postaccident examination of the airframe and engine did not reveal any anomalies that would have precluded normal operation.NTSB ERA14LA404Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-180 · Gaithersburg, MDThe loss of engine power due to fuel starvation for reasons that could not be determined during postaccident examination of the fuel supply and fuel vent systems.NTSB ERA14LA050Accident · No injuriesLimited investigationFinal reportCessna 170 · Ridgely, MDA total loss of engine power for reasons that could not be determined based on the available evidence.NTSB ERA11LA399Accident · No injuriesLimited investigationFinal reportCessna 182K · Stevensville, MDA total loss of engine power during initial climb for undetermined reasons.NTSB ERA11LA141Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Baltimore, MDAn in-flight overload failure of the left elevator inboard balance weight rib for undetermined reasons.NTSB ERA10TA197Accident · Minor injuriesFinal reportCessna 182P · Frederick, MDA loss of engine power for undetermined reasons following a reported severe turbulence encounter.NTSB ERA09LA269Accident · No injuriesLimited investigationFinal reportCessna 208 · Frederick, MDA loss of engine power due to the failure of one or more compressor turbine blades for an undetermined reason.NTSB NYC08LA075Accident · Minor injuriesLimited investigationFinal reportDean Patrick G Genesis · Laurel, MDThe reason for this occurrence was undetermined.