NTSB investigations, MD
20 cases where the sequence of events included Nose over/nose down.
Cases per year
| 2008 | 1 |
|---|---|
| 2009 | 1 |
| 2010 | 1 |
| 2011 | 2 |
| 2013 | 1 |
| 2014 | 2 |
| 2015 | 1 |
| 2016 | 2 |
| 2017 | 1 |
| 2019 | 2 |
| 2020 | 1 |
| 2022 | 4 |
| 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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '096' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\"))
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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '096' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent")) 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 ERA23LA069Accident · Minor injuriesClass 4 · LimitedFinal reportBellanca 7KCAB · Accident, MDThe pilot’s failure to maintain directional control during the landing roll in crosswind conditions.NTSB ERA22LA429Accident · No injuriesClass 4 · LimitedFinal reportCessna 180 · Ocean City, MDThe pilot’s failure to maintain directional control of the airplane while landing with a crosswind, resulting in the runway excursion and nose over.NTSB ERA22LA245Accident · No injuriesClass 4 · LimitedFinal reportVan Lehn Hatz Classic · Frederick, MDThe pilot’s inadvertent application of the brakes during the landing roll which resulted in a nose over.NTSB ERA22LA203Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Westminster, MDThe student pilot’s failure to attain the proper touchdown point which resulted in a runway overrun.NTSB ERA20LA341Accident · No injuriesClass 3 · LimitedFinal reportTecnam P92 · Centerville, MDThe fatigue failure of the No. 1 cylinder exhaust valve spring retainer due to air trapped in the lubrication system, which resulted in a total loss of engine power.NTSB ERA19LA267Accident · No injuriesClass 3 · LimitedFinal reportGrumman G164 · Berlin, MDThe malfunction of the No. 9 pushrod, which resulted in a total loss of engine power.NTSB GAA19CA464Accident · Minor injuriesData collectionFinal reportCessna 172 · Westminster, MDThe pilot's improper decision to continue the landing with the airplane high and fast during the approach, which resulted in a long landing and a subsequent runway overrun and nose-over.NTSB ERA18LA043Accident · Minor injuriesLimited investigationFinal reportCessna 180 · Frederick, MDThe pilot's improper landing flare, which resulted in a bounced landing and the failure of the left main landing gear tire.NTSB GAA16CA423Accident · No injuriesData collectionFinal reportBeech F33 · Bivalve, MDThe pilot's excessive airspeed during landing, which resulted in a runway overrun, and impact with a ditch.NTSB GAA16CA262Accident · No injuriesData collectionFinal reportPiper PA 18A · Westminster, MDThe pilot's failure to maintain directional control during the landing roll, which resulted in runway excursion, and collision with terrain.NTSB ERA15LA368Accident · No injuriesLimited investigationFinal reportCessna 150M · Mount Airy, MDThe in-flight fatigue failure of the No. 4 cylinder barrel, which resulted in a total loss of engine power.NTSB ERA14TA435Accident · No injuriesFinal reportCessna T210N · Gaithersburg, MDThe pilot’s failure to execute a missed approach after recognizing that the airplane was not aligned with the wet runway, which resulted in a long landing with a tailwind and a subsequent runway overrun.NTSB ERA14CA408Accident · No injuriesData collectionFinal reportDay William L Minicoupe · Baltimore, MDThe pilot/owner/builder's improper weight and balance calculations, which rendered the airplane uncontrollable in the pitch axis.NTSB ERA13CA377Accident · No injuriesData collectionFinal reportCessna 172P · Mitchellville, MDThe pilot’s decision to depart with a known deficiency following a hard landing. Contributing to the accident was an anomaly of the airplane’s nosewheel steering that could not be replicated during post-accident examination.NTSB ERA11CA385Accident · No injuriesData collectionFinal reportCessna 172P · Baltimore, MDThe student pilot's failure to maintain aircraft control following a bounced landing.NTSB ERA11CA178Accident · No injuriesData collectionFinal reportIniziative Industriali Italian SKY Arrow 600 Sport · Ridgely, MDThe pilot's failure to compensate for crosswind conditions and loss of directional control during landing, resulting in a runway excursion and nose over.NTSB ERA10TA197Accident · Minor injuriesFinal reportCessna 182P · Frederick, MDA loss of engine power for undetermined reasons following a reported severe turbulence encounter.NTSB ERA09CA172Accident · No injuriesData collectionFinal reportCessna 182S · Westminster, MDThe pilot's failure to stop the airplane within the available runway after touchdown.NTSB NYC08CA257Accident · Minor injuriesData collectionFinal reportCessna 172S · Stevensville, MDThe flight instructor's inadequate remedial action following the student pilot's improper recovery from a bounced landing.