NTSB investigations, 2003
5 cases where the first occurrence was “Propeller blast or jet exhaust/suction”.
Cases per year
| 1982 | 1 |
|---|---|
| 1983 | 3 |
| 1984 | 3 |
| 1985 | 2 |
| 1987 | 2 |
| 1988 | 2 |
| 1989 | 2 |
| 1990 | 3 |
| 1991 | 1 |
| 1992 | 1 |
| 1993 | 1 |
| 1994 | 1 |
| 1995 | 2 |
| 1996 | 1 |
| 1997 | 2 |
| 1998 | 1 |
| 2000 | 2 |
| 2001 | 2 |
| 2002 | 2 |
| 2003 | 5 |
| 2004 | 1 |
| 2006 | 2 |
| 2007 | 4 |
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\") = 2003
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\" = 360)
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") = 2003 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" = 360) 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 IAD04LA003Accident · No injuriesLimited investigationFinal reportCessna C172R · Lexington, KYThe ground controller's failure to advise the relieving controller information regarding an engine run-up, which subsequently resulted in the flight instructor's inadvertent encounter with jet blast during ground taxi.NTSB LAX04LA043Accident · No injuriesLimited investigationFinal reportCessna 208B · Phoenix, AZthe pilot's improper decision to taxi behind another airplane conducting an engine run-up, which resulted in a jet blast encounter.NTSB CHI03LA280Accident · No injuriesLimited investigationFinal reportCessna 172P · Wichita, KSFailure of the maintenance crew to provide adequate clearance to an active taxiway during the engine run-up. Contributing factors were the failure of the control tower to provide a wake turbulence advisory to the accident aircraft when assigning a taxi route…NTSB DEN03TA103Accident · No injuriesFinal reportCessna R172E · Albuquerque, NMthe student pilot's inadvertent encounter with the jet blast and the subsequent inability to maintain aircraft control.NTSB NYC03LA089Accident · No injuriesLimited investigationFinal reportCessna P206 · Newport, RIThe pilot's inadvertent encounter with propeller blast.