NTSB investigations: Continental 0-200 series, MT
47 cases on aircraft whose registry engine model is Continental 0-200 series. 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
| 1966 | 1 |
|---|---|
| 1967 | 3 |
| 1968 | 1 |
| 1969 | 1 |
| 1970 | 2 |
| 1971 | 3 |
| 1973 | 1 |
| 1974 | 1 |
| 1975 | 1 |
| 1976 | 1 |
| 1977 | 4 |
| 1978 | 4 |
| 1979 | 3 |
| 1980 | 1 |
| 1982 | 2 |
| 1985 | 1 |
| 1988 | 2 |
| 1993 | 2 |
| 1995 | 1 |
| 1996 | 1 |
| 1997 | 3 |
| 2004 | 2 |
| 2005 | 1 |
| 2006 | 1 |
| 2007 | 1 |
| 2008 | 1 |
| 2014 | 2 |
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\" = 'MT' 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'))
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" = 'MT' 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'))
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 WPR14LA305Accident · 1 fatalLimited investigationFinal reportCessna 150M · Russian Flat, MTThe pilot's inadequate preflight performance planning and his operation of the airplane outside of the manufacturer's specified performance limitations, which resulted in his exceedance of the airplane's critical angle of attack and a subsequent aerodynamic…NTSB WPR14LA232Accident · Minor injuriesLimited investigationFinal reportCessna 150F · Ronan, MTA loss of engine power for reasons that could not be determined due to insufficient evidence.NTSB LAX08LA212Accident · Serious injuriesLimited investigationFinal reportCessna 150F · Kalispell, MTA partial loss of engine power during initial climb due to fuel system contamination by a foreign substance. Contributing to the accident was the uneven terrain.NTSB LAX07CA183Accident · No injuriesData collectionFinal reportCessna 210F · Denton, MTThe pilot's decision to abort the landing with insufficient runway available to gurantee obstruction clearance.NTSB SEA06CA178Accident · Minor injuriesData collectionFinal reportCessna 150 · Laurel, MTThe pilot's excessive application of the brakes during an aborted takeoff, which resulted in a nose over.NTSB SEA05CA088Accident · No injuriesData collectionFinal reportCessna 150L · Eureka, MTThe pilot's failure to adequately compensate for the wind conditions during the landing roll. Factors include a 10 knot crosswind, with gusts up to 15 knots, and a taxiway sign near the point where the aircraft exited the runway.NTSB SEA05LA002Accident · Minor injuriesLimited investigationFinal reportCessna 150G · Augusta, MTThe pilot's failure to maintain adequate obstacle clearance which resulted in the in-flight collision with rising terrain. Trees and rising terrain are factors in the accident.NTSB SEA04LA168Accident · 1 fatalLimited investigationFinal reportCessna 150L · Angela, MTThe failure of the pilot to maintain clearance while maneuvering. A factor contributing to the accident was the physical impairment of the pilot due to an elevated blood alcohol level.NTSB SEA98LA011Accident · No injuriesLimited investigationFinal reportCessna 150H · Missoula, MTThe student pilot's failure to maintain directional control.NTSB SEA97LA101Accident · No injuriesLimited investigationFinal reportCessna 150F · Plains, MTThe pilot's failure to adequately compensate for wind conditions during the landing roll. Factors contributing to the accident were gusts and crosswinds.NTSB SEA97LA042Accident · No injuriesLimited investigationFinal reportCessna 150K · Helena, MTThe pilot's failure to maintain directional control.NTSB SEA96LA086Accident · No injuriesLimited investigationFinal reportCessna 150F · Plains, MTthe pilot's excessive use of brakes during the landing rollout.NTSB SEA95LA114Accident · No injuriesLimited investigationFinal reportCessna 150J · Miles City, MTThe flight instructor's inadequate supervision. Factors to the accident were: The student pilot's failure to maintain aircraft control and the downdraft.NTSB SEA93LA189Accident · No injuriesLimited investigationFinal reportCessna 150M · Missoula, MTThe loss of engine power from fuel exhaustion due to inadequate preflt planning/preparation by the PIC. A factor related to the accident was the rough/uneven terrain at the accident site.NTSB SEA93LA083Accident · No injuriesLimited investigationFinal reportCessna 150 · Laurel, MTThe loss of engine power, undetermined.NTSB DEN88LA147Accident · Serious injuriesLimited investigationFinal reportCessna 150C · Fort Peck, MTThe pilot made a takeoff from a muddy, dirt, road. He said that after he become airborne he put his aircraft into a sharp turn in order to avoid some power lines. Although he was successful in avoiding the power lines, he inadvertently stalled the aircraft…NTSB DEN88LA070Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Circle, MTPlt and passenger were hunting coyotes from the air. Upon landing to pick up a coyote they had shot, the acft encountered deep snow and nosed over.NTSB DEN85LA063Accident · No injuriesLimited investigationFinal reportCessna 150 · Missoula, MTOn jan 14, 1985, a Cessna 150 nosed over after landing on a highway near Missoula, MT. The pilot stated he lost partial engine power due to carburetor icing conditions encountered enroute from great falls, MT. The pilot and his passenger were not injured. The…NTSB DEN82DA200Accident · No injuriesFinal reportCessna 150M · Missoula, MTPilot landing after cross-country in windy conditions. He says nose must have hit too hard because nose gear collapsed..NTSB DEN82FTI18Accident · Serious injuriesFinal reportCessna 150 · Conrad, MTPilot had engine lose power momentarily on a previous flight but did not concern himself about it. During this flight power was lost at 4100 feet. Pilot tried restart without success. During landing nose was lowered prior to touchdown and it caught on an…NTSB DEN80FTA12Accident · No injuriesClosedCessna 150 · Winnett, MTNTSB SEA80FTA01Accident · No injuriesClosedCessna 150 · Billings, MTNTSB SEA79FTA14Accident · No injuriesClosedCessna 150 · Billings, MTNTSB SEA79FTI06Accident · No injuriesClosedCessna 150L · Stevensville, MTNTSB SEA79FA008Accident · 1 fatalClosedCessna 150H · Swan Lake, MTNTSB SEA78DTA16Accident · No injuriesClosedCessna 150 · Miles City, MTNTSB SEA78FTI14Accident · Minor injuriesClosedCessna 150 · Hamilton, MTNTSB SEA78DTI07Accident · No injuriesClosedCessna 150M · Conrad, MTNTSB SEA78FTA09Accident · No injuriesClosedCessna 150 · Peerless, MTNTSB SEA77FTI21Accident · No injuriesClosedCessna 150G · Helena, MTNTSB SEA77FTI16Accident · 2 fatalClosedCessna 150M · Helena, MTNTSB SEA77FTA10Accident · No injuriesClosedChampion 7GCAA · Hardin, MTNTSB SEA76FTI32Accident · No injuriesClosedCessna 150D · Lincoln, MTNTSB SEA75DTI19Accident · No injuriesClosedCessna 150 · Wh.Sulphur Spg, MTNTSB SEA74DTI16Accident · No injuriesClosedCessna 150 · Hamilton, MTNTSB SEA74FTA15Accident · No injuriesClosedCessna 150 · Belle Creek, MTNTSB SEA71FTI29Accident · No injuriesClosedCessna 150F · Libby, MTNTSB SEA71FDG26Accident · No injuriesClosedCessna 150 · Plains, MTNTSB SEA71FDA12Accident · No injuriesClosedCessna 150 · Billings, MTNTSB SEA71DDA10Accident · No injuriesClosedCessna 150F · Glendive, MTNTSB SEA70DDA14Accident · No injuriesClosedCessna 150 · Billings, MTNTSB SEA70D0092Accident · No injuriesClosedCessna 150J · Augusta, MTNTSB SEA68D0234Accident · No injuriesClosedCessna 150H · Hamilton, MTNTSB SEA68D0054Accident · No injuriesClosedCessna 150 · Missoula, MTNTSB SEA67D0295Accident · No injuriesClosedCessna 150 · Chester, MTNTSB SEA67D0286Accident · No injuriesClosedCessna 150 · Broadus, MTNTSB SEA67D0110Accident · No injuriesClosedCessna 150F · Belgrade, MT