Ongoing NTSB investigations, MD
180,604 investigations by the National Transportation Safety Board since 1962: 174,583 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 per year
| 2024 | 1 |
|---|---|
| 2025 | 1 |
| 2026 | 6 |
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.\"completionStatus\" = 'Ongoing'
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."completionStatus" = 'Ongoing' 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 ERA26LA343Accident · No injuriesClass 4 · LimitedInvestigation openCirrus Design SR20 · California, MDNTSB ERA26LA312Accident · No injuriesClass 4 · LimitedInvestigation openPiper PA24 · Fort Washington, MDNTSB ERA26LA302Accident · No injuriesClass 4 · LimitedInvestigation openFrank J Salomone RV10 · Stevensville, MDNTSB ERA26LA262Accident · No injuriesClass 4 · LimitedInvestigation openPiper PA-28-161 · Easton, MDNTSB ERA26FA243Accident · 3 fatalClass 3 · FieldPreliminary reportPiper PA-28-181 · Bowie, MDOn June 20, 2026, about 2328 eastern daylight time, a Piper PA-28-181, N249WF, was substantially damaged when it was involved in an accident near Bowie, Maryland. The pilot and two passengers were fatally injured. The airplane was operated as a Title 14 Code…NTSB ENG26LA019IncidentClass 4 · LimitedInvestigation openAirbus A321 · Baltimore, MDNTSB ERA25LA305Accident · No injuriesClass 3 · LimitedPreliminary reportDassault/Sud FAN JET Falcon SER D · Mount Airy, MDOn April 15, 2025, about 0800 eastern daylight time, a Dassault/Sud Fan Jet Falcon Series D, N229CK, was substantially damaged when it was involved in an accident near Mount Airy, Maryland. The airline transport pilot and commercial copilot were not injured.…NTSB ERA24FA305Accident · 1 fatalClass 3 · FieldPreliminary reportCessna 402 · Easton, MDOn July 16, 2024, about 0932 eastern daylight time, a Cessna 402B, N7875E, was substantially damaged when it was involved in an accident near Easton, Maryland. The airline transport pilot was fatally injured. The airplane was operated as a Title 14 Code of…