NTSB investigations: Continental 0-200 series, IA
5 cases on aircraft whose registry engine model is Continental 0-200 series, where the first occurrence was “Loss of control - in flight”. 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
| 1982 | 1 |
|---|---|
| 1987 | 1 |
| 1996 | 1 |
| 1997 | 1 |
| 1999 | 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\" = 'IA' 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\" = 250))
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" = 'IA' 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" = 250))
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 CHI99LA281Accident · No injuriesLimited investigationFinal reportCessna 150M · Perry, IAthe student pilot's inadequate compensation for the wind conditions which resulted in her failure to maintain control of the airplane. A factor associated with the accident was the gusty crosswind condition.NTSB CHI97LA155Accident · No injuriesLimited investigationFinal reportCessna 150 · Woodbine, IAThe pilot's inadequate preflight planning and preparation. Factors were the high temperature and high vegetation.NTSB CHI96LA254Accident · No injuriesLimited investigationFinal reportCessna 150 · Dubuque, IAinadequate airspeed and the student pilot's failure to perform a recovery from the bounced landing. Factors associated with the accident were the crosswind and the student's over compensation for the crosswind.NTSB MKC87FA077Accident · 1 fatalField investigationFinal reportCessna 150-H · Council Bluffs, IAAcquaintances stated that the student pilot was very motivated in the pursuit of his private pilot certificate and that, on the day of the accident, he was looking forward to this first solo flight. According to his instructor-pilot, who also witnessed the…NTSB MKC82DA114Accident · No injuriesFinal reportCessna 150L · Clarinda, IAThe student pilot flared too high during landing, added power and raised the flaps. The aircraft stalled and landed nose and wingtip first and came to rest off the left side of the runway at midfield.