NTSB investigations, 1984
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\") = 1984
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") = 1984 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 CHI85LA064Accident · No injuriesLimited investigationFinal reportPiper PA-22-135 · Plainfield, ILRight wing of acft was lifted by wind while taxiing after landing. Plt was taxiing south then made turn into tie down area when accident occurred. Flaps were down and control wheel was held forward with left aileron input. Acft flipped over. Plt recommended,…NTSB DEN84LA277Accident · No injuriesLimited investigationFinal reportCessna 180 · West Jordan, UTAccording to the plt, at midfield during the landing roll a gust of wind from the west caught the right wing. The acft ground looped collapsing the left main landing gear and damaging the left wing. While the nearest wx observation facility reported wind from…NTSB MKC84LU006Accident · Serious injuriesFinal reportRotec Rally 3 · Grand Island, NEBefore the flt, the instructor saw a thunderstorm approximatetly 20 mi north of the field, moving slowly to the south-southeast. He & the student elected to make a short flt. After taking off, they made a practice forced landing in an open field about 1 mi…NTSB NYC84LA166Accident · No injuriesLimited investigationFinal reportCessna C188 · Seneca Falls, NYPilot attempted to compensate for gusty wnd cond by lnding the acft tail high. The acft began to wx vane and in an effort to correct, the plt used excessive rt brake. The braking action combined with the gusty wnd exceeded the elevator authority and the acft…NTSB MIA84LA159Accident · Minor injuriesLimited investigationFinal reportPiper J-3 · New Smyrna Bch, FLWhile the plt was taxing onto the rwy, the wind picked up the right wing & the acft was blown inverted. The winds were gusting 30 KTS.NTSB LAX84LA226Accident · No injuriesLimited investigationFinal reportCessna 172K · Lancaster, CAThe acft was blown over as it turned crosswind in gusts up to 40 KTS. The plt said he was using the procedures for taxiing in wind conditions. The Cessna 172 is limited to a 15 kt crosswind component for takeoff.NTSB LAX84LA177Accident · Minor injuriesLimited investigationFinal reportCessna 182L · Mammoth Lakes, CAThe plt reported that the acft was blown over as he taxied for takeoff. Also, he reported the wind to be from 200 degrees at 20 KTS. The recorded wind from 180 degrees at KTS gusting to 40 KTS. The maximum demonstrated crosswind component for this acft is 15…