NTSB investigations, 2001, FL
11 cases where the first occurrence was “Loss of control - on ground/water”.
Cases per year
| 1982 | 11 |
|---|---|
| 1983 | 12 |
| 1984 | 12 |
| 1985 | 16 |
| 1986 | 17 |
| 1987 | 15 |
| 1988 | 12 |
| 1989 | 15 |
| 1990 | 10 |
| 1991 | 10 |
| 1992 | 4 |
| 1993 | 8 |
| 1994 | 14 |
| 1995 | 9 |
| 1996 | 10 |
| 1997 | 8 |
| 1998 | 9 |
| 1999 | 11 |
| 2000 | 8 |
| 2001 | 11 |
| 2002 | 17 |
| 2003 | 14 |
| 2004 | 12 |
| 2005 | 14 |
| 2006 | 23 |
| 2007 | 14 |
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\") = 2001
AND c.\"eventStateOrRegion\" = 'FL' 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") = 2001 AND c."eventStateOrRegion" = 'FL' 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 ATL02LA005Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Lake Wales, FLThe pilot's improper decision to land on a wet sod runway which resulted in a loss of directional control during landing. Factors were the wet grass strip which allowed the airplane to hydroplane.NTSB MIA02LA002Accident · No injuriesLimited investigationFinal reportCessna 172R · Wauchula, FLthe pilot's failure to maintain directional control of the aircraft while attempting to take off after executing a touch-and-go landing, in gusty wind conditions, which resulted in a ground swerve, and the aircraft exiting the runway, and incurring…NTSB MIA01LA234Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Melbourne, FLthe pilot's failure to maintain directional control of the aircraft during the landing rollout while landing in gusty crosswind conditions, which resulted in a ground swerve, and the aircraft exiting the runway and incurring substantial damage when it…NTSB MIA01LA124Accident · No injuriesLimited investigationFinal reportNorth American AT-6D · Destin, FLfailure of the flight instructor to maintain directional control of the aircraft during the landing rollout while landing with a crosswind in gusty conditions, which resulted in a ground swerve, and the aircraft exiting the runway and incurring substantial…NTSB MIA01LA118Accident · No injuriesLimited investigationFinal reportCessna 172R · Ormond Beach, FLthe flight instructor's inadequate supervision and the dual student's improper use of brakes which resulted in the loss of directional control and collision with a wind sock. Contributing to the accident was the flight instructor's failure to follow…NTSB MIA01LA090Accident · No injuriesLimited investigationFinal reportCessna 182Q · Melbourne, FLThe failure of the pilot-in-command to maintain directional control of the airplane during the landing roll of the touch-and-go landing resulting in the on ground collision with a ditch and subsequent separation of the nose gear wheel and fork assembly and…NTSB MIA01LA086Accident · No injuriesLimited investigationFinal reportCessna 152 · Naples, FLThe student's failure to maintain control of the aircraft during landing due to his improper landing flare height and improper recovery from a bounced landing, resulting in a nose landing gear collapse, and excursion off the runway.NTSB ATL01LA032Accident · No injuriesLimited investigationFinal reportCessna 208 · Key West, FLThe airplanes' inadvertent collision with a swell during a water landing near a ferry boat that resulted the overload failure of the rear float/strut assembly.NTSB MIA01LA068Accident · No injuriesLimited investigationFinal reportCessna 152 · Edgewater, FLThe student pilot's failure to maintain directional control on landing rollout with a crosswind. This resulted in the airplane departing the runway, colliding with a berm/ridge, becoming airborne, and colliding with the terrain in a nose down attitude.NTSB ATL01LA024Accident · No injuriesLimited investigationFinal reportCessna 152 · St. Augustine, FLThe pilots failure to maintain directional control during the landing roll, which resulted in the collision with the airport sign.NTSB MIA01LA056Accident · Serious injuriesLimited investigationFinal reportMaule MXT-7-180A · Perry, FLThe loss of control on landing due to the student's improper recovery from a bounced landing, and the resulting nose over on the grass runway.