NTSB investigations: Continental 0-200 series, FL
11 cases on aircraft whose registry engine model is Continental 0-200 series, where the first occurrence was “Hard landing”. 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
| 1987 | 1 |
|---|---|
| 1988 | 1 |
| 1989 | 1 |
| 1994 | 3 |
| 1995 | 1 |
| 1997 | 2 |
| 1998 | 1 |
| 2003 | 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\" = 200))
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" = 200))
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 MIA03CA041Accident · Serious injuriesData collectionFinal reportCessna 150K · Everglades City, FLThe instructor's failure to maintain airspeed during climb after lift off from an aborted landing, resulting in the airplane stalling, entering a spin, and crashing into water at the departure end of the runway. Contributing to the accident was the…NTSB MIA99LA021Accident · No injuriesLimited investigationFinal reportCessna 150F · Winter Haven, FLThe student pilot's improper landing flare resulting in a hard landing and ground loop.NTSB MIA97LA170Accident · No injuriesLimited investigationFinal reportCessna 150F · Venice, FLfailure of the pilot to maintain sufficient airspeed on final approach and during the landing to properly flare the airplane.NTSB MIA97LA114Accident · No injuriesLimited investigationFinal reportCessna 150G · St. Petersburg, FLthe student pilot's improper level off.NTSB MIA95LA146Accident · No injuriesLimited investigationFinal reportCessna 150G · Archer, FLThe pilot's improper landing flare/touchdown resulting in a hard/bounced landing, and subsequent nose over. Contributing to the accident was the pilot's improper recovery from a bounced landing.NTSB MIA94LA201Accident · No injuriesLimited investigationFinal reportMankovich Parakeet · Fernandina Bch, FLThe improper flare by the pilot-in-command resulting in the hard landing, and the pilot's failure to perform a recovery from the bounced landing. Contributing to the accident was the pilot's lack of total time in this type airplane.NTSB MIA94LA151Accident · No injuriesLimited investigationFinal reportCessna 150H · Sugarloaf Key, FLThe improper flare and improper recovery from a bounced landing by the pilot-in-command.NTSB MIA94LA088Accident · No injuriesLimited investigationFinal reportCessna 150M · Vero Beach, FLThe failure of the student pilot to properly recover from a bounced landing.NTSB MIA89LA197Accident · No injuriesLimited investigationFinal reportCessna 150 · Deland, FLImproper flare by the pilot and his improper recovery from a bounced landing.NTSB MIA88LA222Accident · No injuriesLimited investigationFinal reportCessna 150G · Keystone Height, FLWhile on a personal flt during the seventh touch & go landing, the acft bounced & drifted off the left side of the rwy. The plt added power & rolled the acft into a right bank to correct this but the right wing collided with terrain. The acft then nosed over…NTSB MIA87LA245Accident · No injuriesLimited investigationFinal reportCessna 150M · Morriston, FLDrg a lndg on the student plt's 3rd solo flt, the acft ballooned after it touched down. The student stated that she failed to add power & the stall warning horn sounded. The acft then touched down hard & the nose gear failed.