NTSB investigations, 1982, SC
3 cases where the first occurrence was “Overrun”.
Cases per year
| 1982 | 3 |
|---|---|
| 1983 | 1 |
| 1984 | 3 |
| 1986 | 3 |
| 1988 | 1 |
| 1989 | 2 |
| 1993 | 1 |
| 1997 | 1 |
| 1998 | 1 |
| 2000 | 1 |
| 2001 | 1 |
| 2002 | 1 |
| 2005 | 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 year(c.\"eventDate\") = 1982
AND c.\"eventStateOrRegion\" = 'SC' 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 year(c."eventDate") = 1982 AND c."eventStateOrRegion" = 'SC' 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 ATL82DA262Accident · No injuriesFinal reportGrumman AA5B · Darlington, SCWind shifted to tailwind as pilot was landing. He considered a go-around because of speed but thought he could stop. As he went off the end the wing collided with a tree.NTSB ATL82DA056Accident · No injuriesFinal reportPiper PA-28-161 · Ridgeland, SCAfter touching down on the first 1/3RD of the 3100 foot runway the pilot stated that he lost his brakes. The aircraft went off the departure end of the runway down a 25 foot embankment and turned over. Examination of the wheel brake system including pushing…NTSB ATL82DLG09Accident · No injuriesFinal reportCessna 152 · Grantiteville, SCThe pilot was unable to find the airport at his intended destination. He saw another airport and elected to land. A no-flap approach was made to rwy 24 with a north wind. The aircraft touched down about 500 feet from the departure end and then became airborne…