NTSB investigations, 2018, MD
5 cases where the sequence of events included Collision with terr/obj (non-CFIT).
Cases per year
| 2008 | 8 |
|---|---|
| 2009 | 3 |
| 2010 | 7 |
| 2011 | 8 |
| 2012 | 6 |
| 2013 | 9 |
| 2014 | 4 |
| 2015 | 12 |
| 2016 | 5 |
| 2017 | 6 |
| 2018 | 5 |
| 2019 | 8 |
| 2020 | 4 |
| 2021 | 5 |
| 2022 | 3 |
| 2023 | 3 |
| 2024 | 2 |
| 2025 | 1 |
| 2026 | 3 |
Where
Latest 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 year(c.\"eventDate\") = 2018
AND 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\" = '470' 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 year(c."eventDate") = 2018 AND 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" = '470' 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 GAA18CA505Accident · No injuriesData collectionFinal reportCessna 172 · Churchville, MDThe pilot's failure to maintain directional control after landing left of the runway centerline, which resulted in a runway excursion and impact with a power box.NTSB ERA18FA221Accident · 2 fatalField investigationFinal reportQuicksilver MXL II Sport · Westminster, MDThe in-flight fracture of a stainless steel bolt that was used to secure the upper and lower wing cables to the outer attach point at the leading edge spar of the right wing due to stress corrosion cracking, which caused the right wing to fail and precluded…NTSB ERA18LA211Accident · No injuriesLimited investigationFinal reportSchweizer SGS233 · Churchville, MDThe pilots' decision to take off from a wet, upsloping turf runway with a quartering tailwind and elevated density altitude conditions, which degraded takeoff and climb performance and resulted in the glider flight instructor's decision to discontinue the…NTSB ERA18LA181Accident · Serious injuriesClass 3 · LimitedFinal reportBeech 35B33 · Berlin, MDThe failure of the No. 3 cylinder exhaust valve, which resulted in the total loss of engine power during takeoff.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.