NTSB investigations, 2002, SC
4 cases where the first occurrence was “Loss of control - in flight”.
Cases per year
| 1982 | 6 |
|---|---|
| 1983 | 5 |
| 1984 | 5 |
| 1985 | 3 |
| 1986 | 3 |
| 1987 | 4 |
| 1988 | 2 |
| 1989 | 5 |
| 1990 | 2 |
| 1991 | 4 |
| 1992 | 2 |
| 1993 | 1 |
| 1994 | 5 |
| 1995 | 5 |
| 1996 | 3 |
| 1997 | 3 |
| 1998 | 1 |
| 1999 | 3 |
| 2000 | 3 |
| 2001 | 2 |
| 2002 | 4 |
| 2003 | 3 |
| 2004 | 1 |
| 2005 | 4 |
| 2006 | 6 |
| 2007 | 5 |
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\") = 2002
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\" = 250)
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") = 2002 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" = 250) 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 ATL02FA150Accident · 2 fatalField investigationFinal reportPiper PA-28-140 · Spartanburg, SCThe pilot's failure to maintain airspeed during the takeoff initial climb which resulted in an inadvertent stall and subsequent collision with an embankment.NTSB MIA02LA125Accident · No injuriesLimited investigationFinal reportMooney M20R · Mt. Pleasant, SCThe pilot's failure to maintain airspeed resulting in a stall, an uncontrolled descent, and an impact with the ground during the attempted go-around.NTSB ATL02LA122Accident · No injuriesLimited investigationFinal reportCessna 172R · N Myrtle Beach, SCThe pilot's failure to maintain airspeed during a banner tow pickup resulting in an inadvertent stall and uncontrolled descent and collision with terrain.NTSB ATL02FA063Accident · 2 fatalField investigationFinal reportPiper PA-28-160 · Laurens, SCThe pilot experienced spatial disorientation, which resulted in a loss of control and the subsequent collision with terrain. Factors were low clouds and dark-night.