NTSB investigations: Continental 0-200 series, 1983, WA
11 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
| 1964 | 2 |
|---|---|
| 1965 | 3 |
| 1966 | 10 |
| 1967 | 4 |
| 1968 | 11 |
| 1969 | 9 |
| 1970 | 9 |
| 1971 | 4 |
| 1972 | 3 |
| 1973 | 4 |
| 1974 | 2 |
| 1975 | 8 |
| 1976 | 4 |
| 1977 | 3 |
| 1978 | 7 |
| 1979 | 4 |
| 1980 | 1 |
| 1981 | 2 |
| 1982 | 4 |
| 1983 | 11 |
| 1985 | 5 |
| 1986 | 2 |
| 1987 | 4 |
| 1988 | 2 |
| 1989 | 2 |
| 1990 | 2 |
| 1991 | 2 |
| 1993 | 3 |
| 1994 | 2 |
| 1995 | 2 |
| 1996 | 3 |
| 1997 | 3 |
| 1998 | 2 |
| 1999 | 3 |
| 2000 | 5 |
| 2001 | 3 |
| 2002 | 3 |
| 2003 | 1 |
| 2004 | 4 |
| 2005 | 4 |
| 2006 | 1 |
| 2007 | 3 |
| 2009 | 1 |
| 2010 | 2 |
| 2011 | 2 |
| 2012 | 2 |
| 2013 | 3 |
| 2015 | 2 |
| 2017 | 1 |
| 2018 | 2 |
| 2019 | 1 |
| 2020 | 2 |
| 2022 | 2 |
| 2023 | 3 |
| 2024 | 3 |
| 2025 | 1 |
| 2026 | 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 year(c.\"eventDate\") = 1983
AND c.\"eventStateOrRegion\" = 'WA' 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 year(c."eventDate") = 1983
AND c."eventStateOrRegion" = 'WA' 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 SEA84LA027Accident · No injuriesLimited investigationFinal reportCessna 150F · Prosser, WAAccording to the pilot shortly after departure the engine began running rough for the second time. The pilot elected to make a precautionary landing on a gravel road he was familiar with. During the landing flare, with a gusty crosswind, directional control…NTSB SEA83LA199Accident · No injuriesLimited investigationFinal reportBellanca Gcbc · Spokane, WAAccording to the operator, the plt was practicing touch & go landings. During a landing, the acft ground looped & the left horizontal stabilizer struck a VASI light. The plt reported that he had 4.2 hrs in this make & model.NTSB SEA83FA186Accident · Serious injuriesField investigationFinal reportCessna 150F · Bellingham, WAThe plt & passenger departed on a local sight-seeing flt. While flying low over the narrow part of lake samish, the acftcollided with a power line, then crashed in the water. The power lines were 129 ft above the water at the lowest point.NTSB SEA83FA178Accident · 1 fatalField investigationFinal reportCessna 150 · Granite Falls, WAThe acft collided with the ground in a vertical nose down attitude. The engine was imbedded 4 ft into the ground. All components of the acft were accounted for in the immediate area of the impact. Witnesses observed the acft in a left turn before falling into…NTSB SEA83LA164Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Port Orchard, WAThe acft stalled into trees during an attempted go-around after a simulated forced landing. This was a dual instructional flight. During the simulated landing maneuver the student located a grass strip and approached into the wind. At about 30-50 ft a…NTSB SEA83LA148Accident · Serious injuriesLimited investigationFinal reportCessna 150-J · Connell, WAThe plt stated he was preparing to shut down the engine when the passenger deplaned & inadvertently walked into the prop.NTSB SEA83LA117Accident · Minor injuriesLimited investigationFinal reportCessna 150H · Yakima, WAThe acft nosed over during an off airport forced landing. The student pilot had checked with her father and flight instructor for her cross-country flight. Her father supplied information on the fuel supply and the student and instructor used this information…NTSB SEA83LA125Accident · No injuriesLimited investigationFinal reportCessna 150 · Kelso, WAThe plt hand-propped the acft with a non-plt at the controls. The acft was then taxied to the fuel pumps & fueled. The acft was then hand-propped again with no chocks used. The non-plt was at the controls. The acft started to move, & the plt climbed into the…NTSB SEA83LA076Accident · No injuriesLimited investigationFinal reportCessna 150F · Anacortes, WAThe uncertificated plt had made several attempts to land when he struck a tree in the approach path with the right wing. The acft then left the area for a short period of time, returned & made what was described as a bumpy landing. The acft use was…NTSB SEA83LA061Accident · No injuriesLimited investigationFinal reportCessna C-150L · Near Bremerton, WAPilot landed on a wet muddy airstrip and lost directional control during rollout. The aircraft collided with an abandoned auto parked off the side of the runway. The pilot reported the field was wet/muddy and that an unexpected tailwind increased his landing…NTSB SEA83LA048Accident · No injuriesLimited investigationFinal reportCessna 150M · Mesa, WADuring a short/soft field landing, the nose gear collapsed and the aircraft nosed over. The instructor was demonstratingthe landing at a private airstrip. He reported that upon touchdown, the aircraft rolled about 50 feet, then the nose gear dug in and the…