Skip to content

NTSB investigations: Continental 0-300 series, WV

26 cases on aircraft whose registry engine model is Continental 0-300 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19652026

Where

Latest cases

Query with SQL

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" = 'WV' 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 ('17022')) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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\" = 'WV' 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 ('17022'))
  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" = 'WV' 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 ('17022'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

Run 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 ERA23LA190Accident · No injuriesClass 3 · LimitedFinal reportCessna 172H · Charles Town, WVA loss of engine power for undetermined reasons.Apr 11, 2023 · N2554L · Substantial damage NTSB NYC07CA204Accident · Minor injuriesData collectionFinal reportCessna 172 · Julian, WVThe pilot's inadequate preflight planning. Contributing to the accident were the overcast cloud conditions and the pilot's failure to maintain directional control during the landing roll.Aug 26, 2007 · N6670A · Substantial damage NTSB IAD05LA013Accident · No injuriesLimited investigationFinal reportCessna 172E · Rupert, WVThe pilot’s delayed application of carburetor heat, which resulted in a rough running engine. A factor was the bulldozer on the logging road where the pilot performed a precautionary landing.Nov 21, 2004 · N3750S · Substantial damage NTSB NYC01LA142Accident · Minor injuriesLimited investigationFinal reportCessna 170A · South Charlesto, WVThe pilot's failure to maintain directional control while landing.Jun 11, 2001 · N9509A · Substantial damage NTSB NYC00FA226Accident · 1 fatalField investigationFinal reportCessna 172 · Davis, WVThe pilot-in-command's inadequate weather evaluation, which resulted in a takeoff with a tailwind, and a subsequent inadvertent stall. Factors were a high gross weight, a high density altitude, and a tailwind.Aug 12, 2000 · N8874B · Substantial damage NTSB NYC00LA202Accident · No injuriesLimited investigationFinal reportCessna 172H · Rainelle, WVThe pilot's failure to maintain a proper decent rate. A factor was the up-sloping runway.Jul 16, 2000 · N1748F · Substantial damage NTSB NYC00LA099Accident · No injuriesLimited investigationFinal reportCessna 172 · Sissonville, WVThe pilot's failure to maintain runway alignment during takeoff. A factor in the accident was wind gusts.Mar 26, 2000 · N7879T · Substantial damage NTSB BFO93LA183Accident · No injuriesLimited investigationFinal reportCessna 170B · Martinsburg, WVThe pilot's failure to maintain directional control.Sep 22, 1993 · N8081A · Substantial damage NTSB NYC92LA182Accident · No injuriesLimited investigationFinal reportCessna 172H · New Cumberland, WVThe pilot's improper takeoff procedures and his lack of understanding of airplane performance which resulted in an aborted takeoff with insufficient runway to stop and the subsequent collision with a fence. Factors related to the accident were; the pilot's…Aug 25, 1992 · N1109F · Substantial damage NTSB BFO89LA025Accident · No injuriesLimited investigationFinal reportCessna 170A · Ravenswood, WVThe pilots decision to land with a tailwind and inadequately compensating for the wind conditions.Mar 23, 1989 · N9187A · Substantial damage NTSB ATL82FA109Accident · 3 fatalClosedCessna 172F · Wolf Pen, WVJul 20, 1981 · N8391U · Destroyed NTSB NYC81FGM08Accident · No injuriesClosedCessna 172H · New Cumberland, WVDec 10, 1980 · N8237L · Substantial damage NTSB IAD79PGN26Accident · No injuriesClosedCessna 172 · New Cumberland, WVMay 19, 1979 · N1109F · Substantial damage NTSB IAD78DIJ05Accident · No injuriesClosedCessna 172 · Fairmont, WVDec 4, 1977 · N5738T · Substantial damage NTSB IAD77FGM22Accident · No injuriesClosedCessna 172 · New Cumberland, WVMay 7, 1977 · N8237L · Substantial damage NTSB IAD76FGM06Accident · No injuriesClosedCessna 172H · New Cumberland, WVSep 2, 1975 · N8237L · Substantial damage NTSB IAD75FIJ12Accident · No injuriesClosedCessna 172 · Ellamore, WVNov 20, 1974 · N8614U · Substantial damage NTSB IAD73FI620Accident · No injuriesClosedCessna 172B · Berkely Spgs, WVMar 11, 1973 · N7764X · Substantial damage NTSB IAD70A0008Accident · 3 fatalClosedCessna 172 · Amherstdale, WVJul 27, 1969 · N8460X · Destroyed NTSB DIA69D0113Accident · No injuriesClosedCessna 172 · Bridgeport, WVOct 20, 1968 · N2008Y · Substantial damage NTSB DIA68F0127Accident · No injuriesClosedCessna 172F · N.Cumberland, WVNov 21, 1967 · N8350U · Substantial damage NTSB NYC67D0336Accident · No injuriesClosedCessna 172 · Charleston, WVOct 20, 1966 · N6272E · Substantial damage NTSB NYC66D0698Accident · Minor injuriesClosedCessna 172 · Charleston, WVDec 30, 1965 · N2413U · Substantial damage NTSB NYC66A0061Accident · Serious injuriesClosedCessna 172 · Petersburg, WVNov 30, 1965 · N8147U · Minor damage NTSB NYC66D0018Accident · No injuriesClosedCessna 172 · Hillsboro, WVMay 24, 1965 · N8774B · Substantial damage NTSB NYC65D0180Accident · No injuriesClosedCessna 172 · Parsons, WVMar 12, 1965 · N5550T · Substantial damage