NTSB investigations, DE
5 cases where the first occurrence was “Overrun”.
Cases per year
| 1983 | 1 |
|---|---|
| 1984 | 1 |
| 1997 | 1 |
| 1998 | 1 |
| 1999 | 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\" = 'DE' 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\" = 340)
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" = 'DE' 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" = 340) 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 NYC99LA183Accident · No injuriesLimited investigationFinal reportCessna 172G · Dover, DEThe student pilot's failure to execute a go-around. Factors include excessive airspeed on the final approach, and the student pilot's attempt to land beyond a safe touchdown point.NTSB IAD98LA081Accident · Minor injuriesLimited investigationFinal reportCessna 172G · Dover, DEThe pilot's failure to attain the proper touchdown point.NTSB IAD98LA003Accident · No injuriesLimited investigationFinal reportCessna 152 · Dover, DEThe pilot's misjudgment of distance and speed which resulted in an overrun of the runway.NTSB NYC84LA298Accident · No injuriesLimited investigationFinal reportBeech A23-24 · Eagle Crest, DEAfter landing the plt used power to continue taxiing to the end of the wet grass rwy. Stopping distance was misjudged when braking began and the acft overran the rwy colliding with a small ditch. One main gear and the nose gear collapsed.NTSB NYC83LA250Accident · No injuriesLimited investigationFinal reportCessna C172M · Dover, DEThe acft ran off the end of the rwy, groundlooped, and collided with a tree during an effort to avoid a blast fence. The landing, made at night with touchdown occurring too FAR down the rwy. An approach had already been abandoned due to excessive airspeed,…