NTSB investigations: Continental 0-200 series, IN
9 cases on aircraft whose registry engine model is Continental 0-200 series, where the first occurrence was “Loss of engine power(total) - nonmechanical”. 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 |
|---|---|
| 1985 | 1 |
| 1987 | 1 |
| 1991 | 2 |
| 1993 | 2 |
| 1994 | 1 |
| 2004 | 1 |
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\" = 'IN' 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\" = 353))
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" = 'IN' 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" = 353))
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 CHI04LA057Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Corydon, INThe student pilot become lost during the cross country flight and the instructor's inadequate supervision of both the flight and preflight planning. This led to the in-flight loss of engine power due to fuel exhaustion, a forced landing, and impact with…NTSB CHI94LA257Accident · Minor injuriesLimited investigationFinal reportLattimore-Dwyer Breezy · Goshen, INfuel exhaustion which resulted from the pilot's failure to assure an adequate fuel supply for the flight.NTSB CHI93LA335Accident · No injuriesLimited investigationFinal reportCessna 150J · Rochester, INthe commercial pilot's inadequate preflight planning/preparation.NTSB CHI93LA154Accident · No injuriesLimited investigationFinal reportCessna 150D · Lake Village, INThe pilot in command's inadequate preflight planning.NTSB CHI92LA058Accident · No injuriesLimited investigationFinal reportCessna 150 · Charlestown, INFuel exhaustion. Factors related to the accident were inadequate maintenance of the airplane and the pilot's decision to fly an airplane with known mechanical deficiencies.NTSB CHI91LA221Accident · No injuriesLimited investigationFinal reportCessna 150M · Merrillville, INImproper pre-flight planning and preparation by the pilot-in-command. Factors related to this accident were the pilot-in-commands's inattentiveness concerning the refueling of his airplane, and inadequate fuel supply, inattentive ground personnel, and…NTSB CHI88LA027Accident · No injuriesLimited investigationFinal reportCessna 150J · Patoka, INWhile enroute to Patoka airport for fuel the aircraft experienced fuel exhaustion and the pilot was forced to make an emergency landing in a field. The aircraft landed approximately two miles northeast of the airport. The nose gear of the aircraft became…NTSB CHI85LA361Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Wabash, INThe student plt was on a planned 3 leg x-country. On the second leg, he became ill and was lost for about one hour. He did not refuel as he though enough fuel remained to return to Wabash. The eng stopped about 7 miles from Wabash. The acft nosed down in a…NTSB CHI82DA130Accident · No injuriesFinal reportCessna 150 · Gary, INThe aircraft engine quit on final approach to landing at Gary municipal. A forced landing was made on a street and the aircraft collided with a street sign before nosing over into a ditch. The aircraft operator examined the aircraft at thescene and said the…