NTSB investigations, 1983
7 cases where the first occurrence was “On ground/water encounter with weather”.
Cases per year
| 1982 | 7 |
|---|---|
| 1983 | 7 |
| 1984 | 7 |
| 1985 | 16 |
| 1986 | 22 |
| 1987 | 21 |
| 1988 | 10 |
| 1989 | 14 |
| 1990 | 17 |
| 1991 | 15 |
| 1992 | 10 |
| 1993 | 5 |
| 1994 | 6 |
| 1995 | 3 |
| 1996 | 7 |
| 1997 | 6 |
| 1998 | 6 |
| 1999 | 15 |
| 2000 | 12 |
| 2001 | 7 |
| 2002 | 9 |
| 2004 | 6 |
| 2005 | 3 |
| 2006 | 5 |
| 2007 | 8 |
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\" = 330)
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" = 330) 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 ATL84LA062Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Charlotte, NCDuring a wx briefing, before takeoff, the plt was advised that the winds at Charlotte, NC were forcast to be from 230 at 13 gusting to 24 KTS. He was also advised to expect moderate to severe turbulence as well as high en route winds. While en route, he…NTSB LAX84LA075Accident · No injuriesLimited investigationFinal reportCessna 180 · Ocotillo Wells, CAThe plt reported that during arrival, he checked for the wind conditions & there appeared to be a light x-wing of appx 5 to 8 KTS. However, while on the landing roll, he encounter an unexpected wind that yawed the acft to the left. Subsequently, the acft…NTSB DEN83LA182Accident · No injuriesLimited investigationFinal reportHelio Courier H-295 · Salt Lake City, UTBefore starting his takeoff, the plt waited for other acft in the pattern to make touch-and-go landings. Immediately before & during his attempted takeoff, the plt saw 2 national guard helicopters hovering over a sod area, west of rwy 34. Reportedly, the 1st…NTSB FTW83LA283Accident · No injuriesLimited investigationFinal reportCessna A-188B · Branch, LAAccording to the plt, the acft was using a longer than normal takeoff roll while taking off with the last load of the day. When he realized it was too late to abort, he dumped his load & continued the takeoff. The landing gear went thru a fence at the end of…NTSB FTW83LA154Accident · No injuriesLimited investigationFinal reportCessna 152 · Mcallen, TXThe student plt landed at an en route airport after completing the second leg of a solo cross-country flt. He stated that after landing, he taxied to a hanger in order to rest before departure. While preparing to depart, he taxied & stopped short of runway 31…NTSB FTW83LA163Accident · No injuriesLimited investigationFinal reportPiper PA-22-125 · Lajitas, TXThe student plt was on a supervised cross-country flight flt. After arriving at an en route airport, he landed on runway 22 with an estimated crosswind from 310 deg at 10 gusting 20 KTS. After decelerating to taxi speed on the runway, a gust of wind was…NTSB ANC84LA001Accident · Minor injuriesLimited investigationFinal reportCessna 185 · Togiak, AKAccording to the plt, he was assisted by a wing walker while taxiing to the takeoff position. The wind had been increasing steadily during his stop & it changed direction as he arrived at the takeoff position. As he turned the acft into position on rwy 27,…