NTSB investigations, 2002, TX
10 cases where the first occurrence was “Loss of control - on ground/water”.
Cases per year
| 1982 | 28 |
|---|---|
| 1983 | 35 |
| 1984 | 25 |
| 1985 | 14 |
| 1986 | 20 |
| 1987 | 26 |
| 1988 | 16 |
| 1989 | 11 |
| 1990 | 12 |
| 1991 | 6 |
| 1992 | 6 |
| 1993 | 11 |
| 1994 | 10 |
| 1995 | 7 |
| 1996 | 9 |
| 1997 | 15 |
| 1998 | 12 |
| 1999 | 15 |
| 2000 | 12 |
| 2001 | 11 |
| 2002 | 10 |
| 2003 | 10 |
| 2004 | 20 |
| 2005 | 12 |
| 2006 | 17 |
| 2007 | 20 |
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\") = 2002
AND c.\"eventStateOrRegion\" = 'TX' 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") = 2002 AND c."eventStateOrRegion" = 'TX' 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 FTW03LA065Accident · No injuriesLimited investigationFinal reportBeech BE-35 · Denver City, TXThe pilot's inadequate compensation for the prevailing wind conditions. A contributing factor was the crosswind.NTSB FTW03LA017Accident · No injuriesLimited investigationFinal reportCessna 172L · San Antonio, TXThe pilot's inadequate compensation for wind resulting in a loss of directional control. A contributing factor was the prevailing crosswind.NTSB FTW03LA001Accident · Minor injuriesLimited investigationFinal reportMaule M-7-235C · San Antonio, TXThe pilot's failure to compensate for the existing winds conditions. A contributing factor was the prevailing tailwind.NTSB FTW02CA207Accident · No injuriesData collectionFinal reportGulfstream American AA-5B · Spicewood, TXthe pilot's failure to maintain directional control during landing roll.NTSB FTW02LA202Accident · Minor injuriesLimited investigationFinal reportJackie SNS-7-Hiperbipe 3 · Lancaster, TXThe pilot's failure to maintain adequate airspeed which resulted in an inadvertent stall. A contributing factor was the pilot's failure to maintain directional control during takeoff roll.NTSB DEN02LA058Accident · No injuriesLimited investigationFinal reportAmerican Champion 8KCAB · Giddings, TXthe failure of the pilot to maintain aircraft control during the landing rollout. A contributing factor was the subsequent inadvertent ground loop of the airplane.NTSB FTW02LA126Accident · Minor injuriesLimited investigationFinal reportCessna 140 · Powderly, TXthe pilot's failure to maintain directional control during the takeoff roll, which resulted in an encounter with muddy terrain and a nose over. Contributing factors to the accident were the crosswind and muddy terrain.NTSB FTW02LA122Accident · No injuriesLimited investigationFinal reportCessna 172R · McKinney, TXthe pilot's failure to maintain directional control of the airplane while taxiing from landing.NTSB ATL02FA058Accident · 1 fatalField investigationFinal reportBeech BE-60 · Mexia, TXThe pilot's failure to remove the control lock before the flight and his failure to follow the checklist.NTSB FTW02LA067Accident · No injuriesLimited investigationFinal reportCessna 172 · Iraan, TXThe pilot's failure to maintain directional control during landing roll. Contributing factors were the pilot's selection of a downwind runway for landing, the tail wind condition, and his lack of total experience in the type of aircraft.