NTSB investigations, 1990
17 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\") = 1990
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") = 1990 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 LAX91LA043Accident · No injuriesLimited investigationFinal reportCessna 172 · Tonopah, NVThe airplane's encounter with a wind gust while taxiing from landing. Contributing factors related to the pilot's improper weather evaluation and his lack of experience in making weather evaluations.NTSB MIA91LA015Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Fort Myers, FLThe failure of the pilot to maintain directional control while landing with shifting gusty winds.NTSB SEA90LA195Accident · No injuriesLimited investigationFinal reportPiper PA18-150 · Enumclaw, WAThe pilot did not maintain directional control of the airplane during the landing roll in gusting wind condition.NTSB NYC90LA217Accident · No injuriesLimited investigationFinal reportPiper PA-16 · Red Hook, NYThe pilot's loss of directional control and departure off the side of the runway during the landing roll, resulting in a collision with a tree. Contributing to the accident was the pilot's lack of expereince in the aircraft.NTSB ANC90LA179Accident · No injuriesLimited investigationFinal reportCessna U206 · Twin Lake, AKInadequate compensation for wind condition.NTSB MIA90LA172Accident · No injuriesLimited investigationFinal reportPiper PA24-260 · Destin, FLThe pilots failure to obtain accurate wind information resulting in the airplane being blown off the runway on landing when a gust which exceeded the crosswind capability of the airplane was encountered.NTSB CHI90LA224Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Sturgis, SDPoor planning/decision, flight into known adverse weather conditions and over confidence in personal ability by the PIC. Contributing factors were thunderstorms, turbulence and unfavorable wind.NTSB LAX90LA273Accident · No injuriesLimited investigationFinal reportCessna 172P · Mammoth Lakes, CAInadvertent encounter with high velocity winds.NTSB DEN90LA132Accident · No injuriesLimited investigationFinal reportLund Mustang II · Hamilton, MTThe inadequate compensation for the wind conditions by the pilot.NTSB LAX90LA207Accident · Minor injuriesLimited investigationFinal reportCessna 180 · Colusa, CAThe pilot's failure to maintain directional control during touchdown.NTSB CHI90LA125Accident · No injuriesLimited investigationFinal reportPiper PA22-150 · Akron, OHPilot's failure to maintain aircraft control while taxiing in gusty crosswind conditions.NTSB FTW90LA105Accident · No injuriesLimited investigationFinal reportCessna 172H · San Angelo, TXThe student failed to maintain directional control of the aircraft during takeoff in variable wind conditions.NTSB LAX90LA149Accident · No injuriesLimited investigationFinal reportCessna 180 · Soledad, CAPilot's failure to maintain directional control during takeoff. Contributing factors were the gusty wind and the crosswind conditions.NTSB DEN90LA049Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Broomfield, COThe pilot's encounter with severe turbulence during landing, and his failure to divert to an alternate airport after becoming aware of the wind conditions. Contributing to the accident was the pilot's low level of experience.NTSB NYC90LA058Accident · No injuriesLimited investigationFinal reportTaylorcraft BC12D · Roxbury, MEPilot factor in that he failed to plan the approach for gusty wind conditions and impacted trees short of the runway.NTSB DEN90LA038Accident · No injuriesLimited investigationFinal reportCessna 182M · Pierre, SDInadequate compensation for the wind conditions by the pilot. An on ground encounter with wind gusts is considered an additional cause.NTSB SEA90LA033Accident · No injuriesLimited investigationFinal reportCessna 172A · Reno, NVThe pilot's improper use of the flight controls. Factors in the accident were the high, gusty wind conditions, the pilot's self induced pressure to arrive at work on time, and his lack of total pilot experience.