NTSB investigations, 1987, SC
4 cases where the first occurrence was “Loss of control - on ground/water”.
Cases per year
| 1982 | 2 |
|---|---|
| 1983 | 3 |
| 1984 | 2 |
| 1985 | 1 |
| 1986 | 1 |
| 1987 | 4 |
| 1988 | 2 |
| 1989 | 3 |
| 1990 | 1 |
| 1991 | 1 |
| 1994 | 4 |
| 1995 | 1 |
| 1997 | 1 |
| 1998 | 2 |
| 1999 | 3 |
| 2001 | 1 |
| 2002 | 2 |
| 2003 | 1 |
| 2005 | 3 |
| 2006 | 1 |
| 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\") = 1987
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\" = 260)
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") = 1987 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" = 260) 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 ATL88LA023Accident · No injuriesLimited investigationFinal reportCessna 152 · Conway, SCThe student plt was performing a normal landing with a crosswind from the left. The acft was drifting to the right at touchdown and was partially off the rwy to the right. The plt attempted to use the brakes and keep the acft's ground track parallel with the…NTSB ATL87LA128Accident · No injuriesLimited investigationFinal reportMaule MX-7-180 · Greenville, SCThe pilot was doing touch and go's to become familiar with his new aircraft. On the fifth landing the aircraft started a groundloop and he recovered by adding full power. On the next landing the aircraft again started a groundloop to the right, he added full…NTSB ATL87LA144Accident · No injuriesLimited investigationFinal reportSpartan 7W · Sumter, SCThe plt reported that the airplane began to turn to the left after ldg when the tailwheel touched down; subsequent efforts to counteract the turn were not successful. The airplane ran off the side of the rwy and hit a depression in the terrain, collapsing the…NTSB ATL87LA054Accident · No injuriesLimited investigationFinal reportCessna 172M · Hartsville, SCThe student plt made two go-arounds before starting his third landing attempt with a variable wind. After touchdown the acft veered to the right and departed the rwy. The plt applied power in an attempt to take-off but the nose wheel hit a hole and the acft…