NTSB investigations, TX
390 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
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 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 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 DFW08CA049Accident · No injuriesData collectionFinal reportCessna 182 · Austin, TXThe pilot's failure to maintain directional control while landing. A contributing factor was the gusting winds.NTSB DFW08LA029Accident · Serious injuriesLimited investigationFinal reportCessna P210N · Midland, TXThe pilot's failure to maintain directional control during the landing roll. Contributing factors were the prevailing tailwind and an airport sign.NTSB DFW08CA023Accident · No injuriesData collectionFinal reportBellanca 7GCBC · Arcola, TXThe loss of control as result of the pilot's failure to compensate for existing wind conditions while landing. A contributing factor was the gusty crosswind.NTSB DFW08CA022Accident · No injuriesData collectionFinal reportAeronca 7AC · Fort Worth, TXThe pilot's failure to maintain direction control. A contributing factor was the tailwind.NTSB DFW07CA210Accident · No injuriesData collectionFinal reportCessna 172 · McKinney, TXThe student pilot's failure to compensate for existing conditions while landing. A contributing factor was the prevailing crosswind.NTSB DFW07CA200Accident · Minor injuriesData collectionFinal reportVans RV-7A · Vernon, TXThe pilot's failure to maintain control of the airplane while landing. A contributing factor was the prevailing tailwind.NTSB DFW07CA195Accident · No injuriesData collectionFinal reportCessna 140 · Lubbock, TXThe pilot's failure to maintain directional control of the airplane while landing. A contributing factor was the flight instructor's delay in taking remedial action.NTSB DFW07CA190Accident · No injuriesData collectionFinal reportKitFox Series 5 · Kerrville, TXThe pilot's failure to compensate for the existing wind conditions. A contributing factor was the prevailing crosswind.NTSB DFW07LA206Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Mason County, TXThe loss of control as result of the collapsed right main landing gear during the landing roll. A contributing factor was the failure of the right main gear as result of corrosion.NTSB DFW07CA175Accident · Minor injuriesData collectionFinal reportMellema Bede 4 · Ennis, TXThe pilot's inability to maintain control of the airplane following the disconnect of the tailwheel steering chain while landing.NTSB DFW07CA177Accident · No injuriesData collectionFinal reportAeronca Champion · Kirbyville, TXThe pilot's inability to maintain directional control during takeoff roll as result of the failure of the airplane's tailwheel's steering arm.NTSB DFW07CA145Accident · No injuriesData collectionFinal reportEvektor sportstar · Grand Prairie, TXLoss of control due to an unexpected crosswind gust. *This report was modified on May 23, 2008.*NTSB DFW07CA139Accident · No injuriesData collectionFinal reportMooney M-20E · Van, TXThe pilot's failure to maintain directional control during the takeoff run.NTSB DFW07CA117Accident · Minor injuriesData collectionFinal reportCessna A188B · Fabens, TXThe pilot's failure to compensate for the existing wind conditions during takeoff. A contributing factor was the crosswind.NTSB DFW07CA106Accident · Minor injuriesData collectionFinal reportCessna 152 · Houston, TXThe student pilot's failure to maintain directional control during landing. A contributing factor was the prevailing crosswind.NTSB DFW07CA097Accident · No injuriesData collectionFinal reportCessna 150E · Levelland, TXThe pilot's failure to compensate for existing wind conditions while landing. A contributing factor was the prevailing crosswind.NTSB DFW07CA101Accident · No injuriesData collectionFinal reportMaule MXT-7-180 · Sierra Blanca, TXThe loss of control as result of the pilot's failure to compensate for the existing wind conditions. A contributing factor was the crosswind.NTSB DFW07IA077Incident · No injuriesIncident investigationFinal reportEmbraer EMB-145LR · Dallas, TXThe pilot's failure to maintain directional control of the airplane while landing with a crosswind. A contributing factor was the prevailing crosswind.NTSB DFW07CA072Accident · No injuriesData collectionFinal reportAmerican Legend AL-11 · Dryden, TXThe pilot's inadequate compensation for the existing crosswind conditions and failure to maintain proper runway alignment.NTSB DFW07CA057Accident · No injuriesData collectionFinal reportLuscombe 8A · El Paso, TXThe pilot's foot becoming lodged behind the right rudder pedal which resulted in a loss of directional control during landing.NTSB DFW07CA048Accident · No injuriesData collectionFinal reportCessna 172S · Spicewood, TXThe pilot's failure to compensate for the existing wind conditions resulting in a loss of directional control. Factors were the gusty crosswind and the muddy terrain.NTSB DFW07CA046Accident · No injuriesData collectionFinal reportCessna 172M · Houston, TXThe pilot's failure to compensate for the existing wind conditions during the landing roll resulting in a loss of control. A contributing factor was the crosswind.NTSB DFW07CA028Accident · No injuriesData collectionFinal reportCessna 172N · Spring, TXLoss of directional control for undetermined reasons.NTSB DFW07CA015Accident · No injuriesData collectionFinal reportMaule M5 · New Braunfels, TXThe failure of the right main landing gear attachment during the landing roll, which resulted in a ground loop. A contributing factor was a crosswind.NTSB DFW07CA013Accident · No injuriesData collectionFinal reportAeronca 65-TAC · Fredricksburg, TXThe pilot's failure to compensate for the existing wind conditions. A contributing factor was the prevailing crosswind.NTSB DFW07CA003Accident · No injuriesData collectionFinal reportBoeing 75 · Sweetwater, TXThe pilot's failure to maintain directional control while landing.NTSB DFW06LA216Accident · 1 fatalLimited investigationFinal reportWeber Venture · El Paso, TXThe aircraft's inadequate landing gear design, which resulted in a loss of directional control and subsequent nose-over. A factor was the owner/builder's failure to incorporate modifications to the landing gear.NTSB DFW06CA202Accident · No injuriesData collectionFinal reportCessna 152 · Gainesville, TXThe pilot's improper recovery from a bounced landing resulting in a porpoise.NTSB DFW06CA196Accident · No injuriesData collectionFinal reportPearson Superfly · Denton, TXThe loss of control as result of the pilot's selection of an unsuitable landing area. A contributing factor was the muddy terrain.NTSB DFW06CA185Accident · No injuriesData collectionFinal reportCessna 120 · Rockwall, TXThe pilot's failure to compensate for existing wind conditions. A contributing factor was the prevailing crosswind.NTSB DFW06CA144Accident · No injuriesData collectionFinal reportMooney M20J · Wichita Falls, TXThe pilot's failure to compensate for existing wind conditions. A contributing factor was the gusty crosswind.NTSB DFW06CA143Accident · No injuriesData collectionFinal reportTaylorcraft BC12-D · Justin, TXThe pilot's improper compensation for the prevailing high wind conditions.NTSB DFW06CA105Accident · No injuriesData collectionFinal reportParks RV-7 · Fort Worth, TXThe pilot's failure to maintain directional control during the takeoff roll. A contributing factor was the prevailing crosswind.NTSB DFW06CA098Accident · No injuriesData collectionFinal reportCessna 172S · Denton, TXThe student pilot's failure to maintain directional control during the takeoff roll.NTSB DFW06CA065Accident · No injuriesData collectionFinal reportRalph Sanders Murphy Acft Elite · Presidio, TXThe pilot's failure to maintain directional control during the takeoff roll.NTSB DFW06CA059Accident · No injuriesData collectionFinal reportPietenpol Aircamper · Lometa, TXThe pilot's failure to maintain directional control while landing. Contributing factors were the sun glare and the rough and uneven landing area.NTSB DFW06LA057Accident · No injuriesLimited investigationFinal reportAgusta A109E · Fort Worth, TXThe pilot's inadvertent encounter with ground resonance which resulted in the destruction of the helicopter.NTSB DFW06CA044Accident · No injuriesData collectionFinal reportChampion 7ECA · Fredericksburg, TXThe pilot's failure to maintain directional control on the landing roll-out. A factor was the crosswind.NTSB DFW06CA035Accident · No injuriesData collectionFinal reportCessna P206 · New Braunfels, TXThe pilot's improper compensation for the existing wind conditions resulting in a loss of control. A contributing factor was the gusty crosswind.NTSB DFW06CA029Accident · No injuriesData collectionFinal reportAeronca 7DC · Saginaw, TXThe flight instructor's delayed remedial action. Contributing factors were the gusty winds.NTSB DFW06CA026Accident · No injuriesData collectionFinal reportCessna 172N · Sherman, TXThe pilot's failure to maintain directional control during takeoff.NTSB DFW06CA004Accident · No injuriesData collectionFinal reportCessna 172 · Spring, TXThe pilot's failure to maintain directional control while landing.NTSB DFW05CA174Accident · No injuriesData collectionFinal reportLearjet 25 · Amarillo, TXThe pilot's failure to maintain directional control during the landing roll. A contributing factor was the prevailing crosswind.NTSB DFW05CA173Accident · No injuriesData collectionFinal reportAyres S-2R · Eagle Lake, TXThe pilot's failure to maintain directional control during landing.NTSB DFW05CA148Accident · No injuriesData collectionFinal reportAermacchi Bosbok AM 3-C · Marfa, TXThe pilot's failure to attain adequate airspeed, and his premature liftoff resulting in a loss of directional control.NTSB DFW05CA108Accident · No injuriesData collectionFinal reportAircraft Mfg & Dev. CH-2000 · Panhandle, TXThe student pilot's improper compensation for existing wind conditions. Contributing factors were the crosswind and inadequate supervision by the flight instructor.NTSB DFW05CA098Accident · No injuriesData collectionFinal reportAir Tractor AT-602 · Crosbyton, TXThe pilot's failure to mantain directional control during take-off. A contributing factor was the dust devil.NTSB DFW05CA060Accident · No injuriesData collectionFinal reportSabreliner 40 · San Antonio, TXThe failure of the aircraft hydraulic system as result of improper maintenance by company maintenance personnel.NTSB DFW05CA050Accident · No injuriesData collectionFinal reportReinhart GP-4 · Fort Worth, TXThe pilot's failure to compensate for the prevailing crosswind. A contributing factor was the crosswind.NTSB DFW05CA046Accident · No injuriesData collectionFinal reportCessna 172P · Houston, TXThe pilot's failure to maintain directional control during the landing roll. A contributing factor was the muddy condition of the terrain.