NTSB investigations, MD
6 cases where the first occurrence was “On ground/water encounter with terrain/water”.
Cases per year
| 1983 | 1 |
|---|---|
| 1985 | 1 |
| 1987 | 2 |
| 1990 | 1 |
| 2001 | 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 o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 320)
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 o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 320) 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 IAD01LA072Accident · No injuriesLimited investigationFinal reportBellanca 8GCBC · Berlin, MDpilot's failure to maintain directional control during landing roll. A factor was the crosswind.NTSB BFO90LA040Accident · No injuriesLimited investigationFinal reportLake LA-4-200 · Have De Grace, MDThe pilot failed to maintain directional control, and used excessive braking trying to regain control.NTSB BFO87FA065Accident · No injuriesField investigationFinal reportBeech 58 · Baltimore, MDDuel alternator failure occurred abt 13 min aft dept. The acft returned and lndd uneventfully. However, while taxiing back to the maint hgr the plt failed to follow the marked taxiway and collided with a ditch. Construction was taking place on the arpt and…NTSB BFO87LA045Accident · No injuriesLimited investigationFinal reportBeech A23-19 · Cambridge, MDWhen the aircraft failed to start the pilot set the throttle, insured the aircraft was tied down and attempted to start the aircraft by hand propping. The aircraft started immediately, broke both tie-down ropes, traveled across the field into a ditch and…NTSB BFO85LA059Accident · No injuriesLimited investigationFinal reportCessna 182RG · Stevensville, MDAfter landing to the left of the centerline of rwy 10, the acft veered left off the rwy and collided with a drainage ditch located approximately 10 yards from the rwy. Following contract with the ditch, at approximately 15 mph, the acft flipped over, coming…NTSB ATL83LA123Accident · No injuriesLimited investigationFinal reportScheibe Flugzeugbau L SPATZ-55 · Woodbine, MDThe aircraft collided with a snowbank during landing roll. The turf landing site was clear but snow had been piled two to four feet deep alongside the strip during the clearing process. As the aircraft neared the end of the strip during landing the pilot…