NTSB investigations: Continental 0-200 series, FL
10 cases on aircraft whose registry engine model is Continental 0-200 series, where the first occurrence was “Loss of control - on ground/water”. Aircraft are matched to the registry by N-number and event date, checked against the reported serial number, make and model, so older matches can be wrong.
Cases per year
| 1983 | 1 |
|---|---|
| 1988 | 1 |
| 1989 | 1 |
| 1994 | 1 |
| 1995 | 1 |
| 1996 | 2 |
| 1998 | 1 |
| 2001 | 1 |
| 2002 | 1 |
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 c.\"eventStateOrRegion\" = 'FL' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('17020')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND 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" = 'FL' AND c."eventCountry" = 'USA'
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('17020')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 260))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESCRun 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 MIA03CA030Accident · No injuriesData collectionFinal reportCessna A150M · Crystal River, FLThe student pilot's improper application of brakes during the landing rollout, which resulted in a loss of directional control and the airplane running off of the runway, impacting a runway light structure, and nosing over.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 MIA98LA199Accident · No injuriesLimited investigationFinal reportCessna 150M · Ormond Beach, FLThe student pilot's failure to maintain directional control.NTSB MIA96LA160Accident · No injuriesLimited investigationFinal reportCessna 150L · Sanford, FLfailure of the pilot to maintain directional control of the airplane during the landing, which resulted in a ground swerve and subsequent nose over.NTSB MIA96LA057Accident · Minor injuriesLimited investigationFinal reportCessna 150J · New Port Richey, FLFailure of the pilot to maintain directional control of the airplane, while landing with a crosswind, which resulted in an inadvertent ground swerve. A factor relating to the accident was: the pilot's lack of recent flying experience.NTSB MIA95LA136Accident · No injuriesLimited investigationFinal reportCessna A150L · Miami, FLThe dual student's improper use of the rudder following a left swerve during landing rollout which prevented the flight instructor from regaining directional control.NTSB MIA95LA007Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Ormond Beach, FLThe pilot's failure to maintain directional control during landing, resulting in an on-ground loss of control, and collision with terrain.NTSB MIA89LA257Accident · No injuriesLimited investigationFinal reportCessna 150L · Rockledge, FLFailure of the student pilot to maintain directional control of the aircraft, which resulted in an inadvertent ground swerve. The gusty crosswind and proximity of the parked aircraft were related factors.NTSB MIA88LA096Accident · No injuriesLimited investigationFinal reportCessna 150 · Titusville, FLStudent pilot lost directional control while landing with right quartering wind. The acft departed the left side of the runway and the nose gear bogged down in sand. The nose gear then failed aft and the acft came to rest on the nose and left wing tip.NTSB MIA83LA116Accident · No injuriesLimited investigationFinal reportCessna 150M · Vero Beach, FLThe acft swerved off the runway, collided with a hole and nosed over during landing roll. This was a student training flight. The student pilot was not injured. The wind was reported as a tail wind.