Skip to content

NTSB investigations: Continental 0-300 series, MA

28 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

19642026

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" = 'MA' 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\" = 'MA' 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" = 'MA' 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 ERA24LA269Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Eastham, MAThe pilot’s inadequate preflight inspection of the airplane’s fuel quantity, which resulted in total loss of engine power due to fuel exhaustion.Jun 16, 2024 · N2710U · Substantial damage NTSB IAD03LA022Accident · Minor injuriesLimited investigationFinal reportCessna 172H · Leeds, MAThe flight instructor's failure to ensure adequate fuel onboard, which resulted in fuel exhaustion and a total loss of engine power.Dec 4, 2002 · N2706L · Substantial damage NTSB NYC03LA025Accident · No injuriesLimited investigationFinal reportCessna 172G · Stow, MAThe pilot's failure to maintain adequate altitude/clearance. A factor in this accident was gusty wind conditions.Nov 23, 2002 · N1152F · Substantial damage NTSB IAD98LA064Accident · No injuriesLimited investigationFinal reportCessna 172D · Beverly, MAfailure of the pilot to maintain control of the airplane during the landing and attempted go-around. A related factor was the crosswind.May 30, 1998 · N2507Y · Substantial damage NTSB NYC97LA150Accident · No injuriesLimited investigationFinal reportCessna 172E · Fitchburg, MAA loss of engine power for undetermined reasons.Jul 22, 1997 · N3553S · Substantial damage NTSB NYC97LA002Accident · No injuriesLimited investigationFinal reportCessna 172H · Chatham, MAthe pilot's improper flare, which resulted in a hard landing. A factor relating to the accident was: the pilot's lack of experience in the make and model of airplane.Oct 5, 1996 · N3707R · Substantial damage NTSB BFO92LA121Accident · No injuriesLimited investigationFinal reportCessna 172H · New Braintree, MAWater contaminated fuel which resulted in the loss of engine power and the pilot's inadequate preflight inspection.Sep 2, 1992 · N2458L · Substantial damage NTSB NYC84LA147Accident · No injuriesLimited investigationFinal reportCessna 152 · Fitchburg, MAThe plt of N45945 stated that upon entering downwind for rwy 32 she reported her position on UNICOM, but did not receivea reply. She continued her approach failing to report base and final positions. At aprx 500 ft on final apch she felt the acft buffet and…Mar 15, 1984 · N45945 · 2 aircraft · No damage NTSB NYC83LA136Accident · No injuriesLimited investigationFinal reportCessna 170A · Chatham, MAThe acft veered onto the grass and nosed over during landing. The pilot said a gust of wind caught the tail of the acft and turned it 45 degrees to the left and when brakes were applied as a corrective action the acft nosed over. The landing was on runway 6…Jun 2, 1983 · N5545C · Substantial damage NTSB NYC79FNA12Accident · No injuriesClosedCessna 172 · Boston, MAJan 29, 1979 · N9701T · Substantial damage NTSB NYC78FNA28Accident · No injuriesClosedCessna 177B · Plymouth, MAJun 4, 1978 · N19708 · 2 aircraft · Substantial damage NTSB NYC78FNA20Accident · No injuriesClosedCessna 172 · Stow, MAApr 22, 1978 · N5927A · Substantial damage NTSB NYC78DNA12Accident · No injuriesClosedCessna 172 · Falmouth, MAJan 28, 1978 · N2934U · Substantial damage NTSB NYC76FNE27Accident · Serious injuriesClosedGlobe GC-1B · Gardner, MAJul 5, 1976 · N78315 · Destroyed NTSB NYC7LFNA17Accident · No injuriesClosedAeronca 15AC · Wareham, MAOct 5, 1975 · N1365H · Substantial damage NTSB NYC74DNA32Accident · No injuriesClosedCessna 172 · Marlboro, MAJan 25, 1974 · N4261L · Substantial damage NTSB NYC70FFD15Accident · No injuriesClosedCessna 172F · Beverly, MAMay 16, 1970 · N8310U · Substantial damage NTSB NYC69D0367Accident · No injuriesClosedCessna 172 · Bedford, MAMar 18, 1969 · N7320T · Substantial damage NTSB NYC69D0289Accident · No injuriesClosedCessna 172H · East Boston, MADec 24, 1968 · N1682F · Substantial damage NTSB NYC69D0026Accident · No injuriesClosedCessna 172 · Norwood, MAJul 6, 1968 · N5838A · Substantial damage NTSB NYC68D0428Accident · No injuriesClosedCessna 172 · Otis Afb, MAApr 16, 1968 · N3568S · Substantial damage NTSB NYC68D0083Accident · No injuriesClosedCessna 172 · Newburyport, MAAug 6, 1967 · N5358R · Substantial damage NTSB NYC66F0593Accident · Minor injuriesClosedCessna 172F · Haverhill, MAMar 30, 1966 · N8556U · Substantial damage NTSB NYC66A0097Accident · No injuriesClosedCessna 172C · East Boston, MAMar 2, 1966 · N1486Y · Substantial damage NTSB NYC65F0145Accident · Minor injuriesClosedCessna 172 · Westboro, MAMay 4, 1965 · N1497Y · Substantial damage NTSB NYC65F0036Accident · No injuriesClosedCessna 172 · Andover, MAFeb 4, 1965 · N7859U · Substantial damage NTSB UNK65X1286Accident · No injuriesClosedCessna 172 · Worcester, MAJan 14, 1965 · N5627A · Substantial damage NTSB UNK64X1941Accident · No injuriesClosedCessna 172 · Edgartown, MAMay 24, 1964 · N2484U · Substantial damage