NTSB investigations, 1997, UT
6 cases where the first occurrence was “Loss of control - on ground/water”.
Cases per year
| 1982 | 8 |
|---|---|
| 1983 | 2 |
| 1984 | 3 |
| 1985 | 3 |
| 1986 | 3 |
| 1987 | 7 |
| 1988 | 4 |
| 1989 | 6 |
| 1990 | 4 |
| 1991 | 7 |
| 1992 | 3 |
| 1993 | 5 |
| 1994 | 4 |
| 1995 | 2 |
| 1996 | 2 |
| 1997 | 6 |
| 1998 | 5 |
| 1999 | 3 |
| 2000 | 6 |
| 2001 | 5 |
| 2002 | 4 |
| 2003 | 6 |
| 2004 | 2 |
| 2005 | 3 |
| 2006 | 4 |
| 2007 | 7 |
Where
Latest 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\") = 1997
AND c.\"eventStateOrRegion\" = 'UT' AND c.\"eventCountry\" = 'USA'
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\" = 260)
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") = 1997 AND c."eventStateOrRegion" = 'UT' AND c."eventCountry" = 'USA' 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" = 260) 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 FTW98LA041Accident · No injuriesLimited investigationFinal reportCessna 172P · Tooele, UTfailure of the pilot to maintain directional control of the airplane, while landing. Factors related to the accident were: the pilot's improper flare for landing, his delay in attempting to go around (abort the landing), and the encounter with a runway marker…NTSB SEA97LA153Accident · Minor injuriesLimited investigationFinal reportCessna TU206G · Halls Crossing, UTThe pilot's failure to adequately compensate for the wind conditions. Factors contributing to the accident were the gusting crosswinds.NTSB SEA97LA139Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Wendover, UTThe pilot's failure to maintain directional control. Factors include the pilot's improper decision to continue his flight into an area where he had observed thunderstorms, and a thunderstorm outflow which created strong wind gusts that the aircraft…NTSB SEA97LA127Accident · No injuriesLimited investigationFinal reportCessna 182 · Brigham City, UTfailure of the pilot to maintain proper runway alignment during the landing. The gusty quartering crosswind was a related factor.NTSB SEA97LA122Accident · No injuriesLimited investigationFinal reportNoe SA-300 · Bountiful, UTthe pilot's failure to maintain directional control of the airplane. Related factors include: an area of standing water on a portion of the runway, and soft terrain just off the edge of the runway.NTSB SEA97LA060Accident · No injuriesLimited investigationFinal reportCessna 172N · Delta, UTThe pilot's failure to adequately compensate for the prevailing wind conditions, and his subsequent failure to maintain directional control during the landing roll. Factors contributing to the accident are a sudden shift in the prevailing wind at the time of…