NTSB investigations, 1982
5 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\") = 1982
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") = 1982 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 ANC83LA004Accident · Serious injuriesLimited investigationFinal reportPiper PA-23-250 · Anchorage, AKShortly after departure the flt received radar vectors placing it near a VFR reporting point located 4 mi past the departure end of rwy 32 & 2 mi east of the rwy centerline. Traffic advisories were issued by approach control indicating a beoing 747 climbing…NTSB LAX82DA306Accident · No injuriesFinal reportHiller UH-12E · Chandler, AZThe pilot was spraying liquid chemicals at night. The pilot flew into his own wake turbulence and lost control and collided with the ground. Control was regained to make an upright landing in the field. Skids were torn off the aircraft.NTSB CHI82DA279Accident · No injuriesFinal reportBell 47G-2 · Plainview, MNWhile making cleanup swaths over an odd shaped portion of a corn field, the pilot made two turns of about 220 degrees each in close proximity to each other. The second turn was made downwind from two previous swaths that had just been completed. During a…NTSB SEA82DA128Accident · Serious injuriesFinal reportAeronca 7AC · Kent, WADuring practice steep turns the aircraft encountered its wake turbulence. Manuevers to regain control were not effective. The aircraft contacted trees in a nose low attitude.NTSB SEA82DA045Accident · No injuriesFinal reportRockwell Intl. S-2R · Eureka, WAAfter spraying most of his load, the pilot made a dry pass and dropped a smoke flare. The flare was dropped to check the drift of the air relative to a susceptible crop east of the field being sprayed. After dropping the flare, the pilot made a 180 degree…