NTSB investigations, 1983, SC
3 cases where the first occurrence was “Loss of engine power(total) - nonmechanical”.
Cases per year
| 1982 | 8 |
|---|---|
| 1983 | 3 |
| 1984 | 3 |
| 1985 | 5 |
| 1986 | 5 |
| 1987 | 4 |
| 1988 | 3 |
| 1989 | 4 |
| 1990 | 4 |
| 1991 | 3 |
| 1992 | 5 |
| 1993 | 8 |
| 1994 | 2 |
| 1995 | 4 |
| 1996 | 3 |
| 1997 | 8 |
| 1998 | 2 |
| 1999 | 7 |
| 2000 | 4 |
| 2001 | 1 |
| 2002 | 1 |
| 2003 | 3 |
| 2004 | 3 |
| 2005 | 3 |
| 2006 | 1 |
| 2007 | 2 |
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\") = 1983
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\" = 353)
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") = 1983 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" = 353) 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 ATL83LA358Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Estill, SCDuring a swath run, the acft began to lose power, so the plt aborted the mission & started back to the arpt to land. However, before reaching the arpt, the eng quit running & the plt landed in a field. During the landing, the acft was extensively damaged. An…NTSB ATL83LA287Accident · No injuriesLimited investigationFinal reportCessna 150 · Johnston, SCThe plt reported that before taking off, he preflighted the acft & estimated that 6 gal of fuel was on board. According to him, the engine lost power aprx 30 min after takeoff & he was unable to restart it. During a forced landing, he intentionally ground…NTSB ATL83LA202Accident · No injuriesLimited investigationFinal reportCessna 195 · Florence, SCAccording to the plt, the eng lost power about 3 mi from the arpt after he switched from the right to the left fuel tank. He reported that he switched the boost pump to the 'high' position, but was unable to restart the eng. He estimated there was 5 to 7 gal…