NTSB investigations, 1982, SC
2 cases where the first occurrence was “Loss of engine power”.
Cases per year
| 1982 | 2 |
|---|---|
| 1983 | 2 |
| 1985 | 2 |
| 1986 | 2 |
| 1987 | 1 |
| 1988 | 1 |
| 1989 | 1 |
| 1991 | 1 |
| 1992 | 1 |
| 1993 | 3 |
| 1994 | 4 |
| 1995 | 4 |
| 1996 | 3 |
| 1997 | 1 |
| 1998 | 4 |
| 1999 | 1 |
| 2001 | 2 |
| 2002 | 2 |
| 2003 | 5 |
| 2004 | 4 |
| 2005 | 3 |
| 2006 | 3 |
| 2007 | 1 |
Where
Latest 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\" = 350)
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" = 350) 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 ATL83FA067Accident · Minor injuriesField investigationFinal reportPiper PA-23-250 · Johns Isle, SCThe plt stated both engs lost power after takeoff & the acft ditched in the stono river. No preimpact failure and/or malfunction of either eng could be found. The plt did not hold any airman certificate.NTSB ATL82FLG08Accident · No injuriesFinal reportMooney M-20J · Hilton Head, SCDuring takeoff at about 200 to 300 feet the engine malfunctioned and the pilot elected to make a gear up landing. Investigation revealed that the left wing fuel tank contained over a quart of water. Water and a red substance similar in appearance to tank…