NTSB investigations, 1983
4 cases where the first occurrence was “Vortex turbulence encountered”.
Cases per year
| 1982 | 5 |
|---|---|
| 1983 | 4 |
| 1984 | 10 |
| 1985 | 7 |
| 1986 | 7 |
| 1987 | 5 |
| 1988 | 9 |
| 1989 | 5 |
| 1990 | 3 |
| 1991 | 3 |
| 1992 | 4 |
| 1993 | 3 |
| 1994 | 1 |
| 1995 | 5 |
| 1996 | 4 |
| 1997 | 4 |
| 1998 | 5 |
| 1999 | 5 |
| 2000 | 5 |
| 2001 | 3 |
| 2002 | 4 |
| 2003 | 3 |
| 2004 | 3 |
| 2005 | 1 |
| 2006 | 3 |
| 2007 | 3 |
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.\"mKey\" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 410)
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."mKey" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 410) 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 LAX83LA334Accident · No injuriesLimited investigationFinal reportCessna A188B · Calipatria, CAThe acft made a hard landing in a cotton field during a crop dusting operation after buffeting was felt in a turn. The pilot thought he was stalling in vortex turbulence from another acft in front of him. A toxic load of suprecide was dumped before the pilot…NTSB MKC83LA155Accident · No injuriesLimited investigationFinal reportCessna A188B · Edgar, NEThe plt reported that he was completing a turnaround when the acft encountered turbulence from another plane that was spraying the same field. The acft began to settle. When he pulled up to avoid a power line, the acft stalled & crashed.NTSB NYC83LA065Accident · No injuriesLimited investigationFinal reportCessna 150K · Wilmington, DEA C-130 aircrew was cleared to taxi to the run-up area at the north end of the arpt for a run-up. At that time, the wind was reported from 360 deg at 8 KTS. The C-130 crew stopped on the run-up pad facing the wind & began a run-up. In the meantime, a Cessna…NTSB LAX83FA098Accident · No injuriesField investigationFinal reportBeech H35 · Tucson, AZDuring arrival, the plt was advised of the position of a Boeing 727 that was landing on rwy 29R & he reported seeing theacft. He also was cautioned about possible wake turbulence from the Boeing & he acknowledged. The plt reported that while he was on an…