NTSB investigations, MD
7 cases where the first occurrence was “Undershoot”.
Cases per year
| 1983 | 1 |
|---|---|
| 1985 | 1 |
| 1990 | 2 |
| 1992 | 1 |
| 1999 | 1 |
| 2006 | 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\" = 390)
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" = 390) 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 NYC07CA053Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Cumberland, MDThe pilot's misjudgment of the airplane's distance/altitude during the landing approach.NTSB NYC00LA041Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Annapolis, MDThe pilot's failure to adequately adjust engine power to compensate for the winds on final approach.NTSB BFO92LA042Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · Stevensville, MDThe certificated flight instructor's (cfi's) inadequate supervision during the simulated emergency landing. Soft terrain in the touchdown area was a related factor.NTSB BFO91LA022Accident · No injuriesLimited investigationFinal reportPiper PA-32R · Mitchellville, MDPilot failure to maintain altitude clearance above an obstacle after the aircraft encountered a downdraft.NTSB BFO90LA055Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Farmington, MDStudent pilot's misjudged approach to landing and the instructor's inadequate supervision.NTSB BFO85FA012Accident · Minor injuriesField investigationFinal reportRockwell Sabreliner/NA265-40 · Glen Burnie, MDWhile on short final the acft was obsvd to nose down into the displaced threshold of rwy 33L. The coplt stated that he sensed that he was getting slow and went to add pwr with his left hand. He was sitting for the first time in the left seat and although he…NTSB ATL83LA204Accident · No injuriesLimited investigationFinal reportMooney M20K · Mitchellville, MDThe acft collided with a chain link fence and a dirt bank on the final approach just prior to touchdown. The fence was about a foot and a half higher than the dirt and the dirt bank was aprx an equal height above the runway. The plt had flown through rain…