Skip to content

NTSB investigations: Cessna 150G, OH

37 cases on aircraft the registry lists as Cessna 150G. 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

19662026

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" = 'OH' AND c."eventCountry" = 'USA' AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2071816')) 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\" = 'OH' AND c.\"eventCountry\" = 'USA'
    AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2071816'))
  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" = 'OH' AND c."eventCountry" = 'USA'
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2071816'))
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 CEN14LA144Accident · No injuriesLimited investigationFinal reportCessna 150 - G · Galion, OHA total loss of engine power on climbout for reasons that could not be determined because postaccident examination of the engine did not reveal any anomalies that would have precluded normal operation.Feb 13, 2014 · N3882J · Substantial damage NTSB CEN13CA343Accident · No injuriesData collectionFinal reportCessna 150G · Franklin, OHThe pilot's improper fuel planning which resulted in a loss of engine power due to fuel exhaustion.Jun 10, 2013 · N3718J · Substantial damage NTSB CHI08CA280Accident · Minor injuriesData collectionFinal reportCessna 150G · Urbana, OHA loss of engine power due to carburetor ice. Contributing to the accident were environmental conditions conducive to carburetor icing.Sep 10, 2008 · N3899J · Substantial damage NTSB CHI06LA087Accident · Serious injuriesLimited investigationFinal reportCessna 150G · Rockford, OHThe fuel exhaustion due to the inadequate preflight planning/preparation by the pilot-in-command. Additional causes were the inadequately planned approach and improper emergency procedure by the pilot-in-command.Feb 24, 2006 · N6366S · Substantial damage NTSB NYC03LA073Accident · No injuriesLimited investigationFinal reportCessna 150G · Medina, OHThe pilot's failure to follow published procedures while starting the engine, and his failure to maintain control of the airplane.Mar 26, 2003 · N3964J · Substantial damage NTSB NYC99LA212Accident · No injuriesLimited investigationFinal reportCessna 150 · Madison, OHThe pilot's delay in using carburetor heat which resulted in a partial loss of engine power, and a forced landing.Aug 26, 1999 · N2475J · Substantial damage NTSB NYC95LA082Accident · No injuriesLimited investigationFinal reportCessna 150G · Dayton, OHthe pilot's inadequate preflight and inflight planning, resulting in fuel exhaustion and loss of engine power, and the subsequent nose over during a forced landing.Apr 2, 1995 · N6293S · Substantial damage NTSB NYC91LA111Accident · No injuriesLimited investigationFinal reportCessna 150G · Phillipsburg, OHThe failure of the pilot to compensate for crosswind conditions during landing, and allowing the airplane to drift off the runway onto soft terrain. A factor relating to the accident was the decision of the pilot to attempt a landing with strong crosswinds.Apr 10, 1991 · N3936J · Substantial damage NTSB NYC91LA075Accident · Minor injuriesLimited investigationFinal reportCessna 150G · Mount Gilead, OHThe pilot's improper use of carburetor heat resulting in an engine failure due to carburetor ice and a subsequent off airport landing in unsuitable terrain.Feb 12, 1991 · N2859S · Substantial damage NTSB ATL89LA094Accident · No injuriesLimited investigationFinal reportCessna 150G · Springboro, OHLoss of power (takeoff) from carburetor ice due to improper use of carburetor heat during extended ground operation using auto fuel in weather which was conducive to icing.Feb 28, 1989 · N2805S · Substantial damage NTSB CHI88FA147Accident · 1 fatalField investigationFinal reportCessna 150G · Plymouth, OHJul 4, 1988 · N2865S · Destroyed NTSB CHI83LA128Accident · No injuriesLimited investigationFinal reportCessna 150D · Wilmington, OHThe aircraft operated by a student pilot swerved off the runway during a touch and go landing and nosed over. The pilot had been practicing touch and go landing for about 40 minutes preceding the accident. During the last landing he toucheddown in a crab and…Mar 5, 1983 · N3064S · Substantial damage NTSB CHI81FEI03Accident · No injuriesClosedCessna 150 · N Philadelphia, OHOct 13, 1980 · N8405J · Substantial damage NTSB CHI80FEK16Accident · No injuriesClosedCessna 150G · Paulding, OHJun 24, 1980 · N6280S · Substantial damage NTSB CHI78FA006Accident · 2 fatalClosedCessna 150G · Columbus, OHNov 4, 1977 · N6221S · Destroyed NTSB CHI75DEG19Accident · No injuriesClosedCessna 150G · Brookville, OHApr 29, 1975 · N4730X · Substantial damage NTSB CHI73FEK13Accident · Serious injuriesClosedCessna 150G · Coldwater, OHDec 22, 1972 · N2741S · Destroyed NTSB CHI73DEG11Accident · No injuriesClosedCessna 150G · Oxford, OHNov 6, 1972 · N2682J · Substantial damage NTSB CHI73DEI17Accident · No injuriesClosedCessna 150G · Minerva, OHOct 9, 1972 · N2217J · Substantial damage NTSB CHI73DEK05Accident · No injuriesClosedCessna 150G · Zanesville, OHAug 22, 1972 · N4740X · Substantial damage NTSB CHI72AC064Accident · 2 fatalClosedCessna 150G · Springfield, OHFeb 12, 1972 · N3629J · 2 aircraft · Destroyed NTSB CHI72DEI05Accident · Minor injuriesClosedCessna 150G · Luckey, OHJul 8, 1971 · N3194J · Substantial damage NTSB CHI71FEK41Accident · Minor injuriesClosedCessna 150G · Columbus, OHJun 27, 1971 · N3683J · Substantial damage NTSB CHI71DGD13Accident · Minor injuriesClosedCessna 150 · Minerva, OHAug 29, 1970 · N3271J · Substantial damage NTSB CHI70FGG13Accident · Minor injuriesClosedCessna 150G · Columbus, OHMar 13, 1970 · N3478J · Substantial damage NTSB CHI70D0398Accident · No injuriesClosedCessna 150 · Painesville, OHDec 28, 1969 · N3875J · Substantial damage NTSB CHI69D0642Accident · Minor injuriesClosedCessna 150 · Willoughby, OHMay 6, 1969 · N3839J · Substantial damage NTSB CHI69D0334Accident · No injuriesClosedCessna 150 · Carrollton, OHOct 5, 1968 · N8506J · Substantial damage NTSB CHI69A0030Accident · No injuriesClosedCessna 150 · Hamilton, OHSep 15, 1968 · N3314J · 2 aircraft · Substantial damage NTSB CHI69F0285Accident · No injuriesClosedCessna 150 · Brunswick, OHSep 1, 1968 · N2900S · Substantial damage NTSB CHI69D0147Accident · Minor injuriesClosedCessna 150 · Carrollton, OHJul 28, 1968 · N3072S · Substantial damage NTSB CHI68D0735Accident · Minor injuriesClosedCessna 150 · S.Russell, OHApr 18, 1968 · N2272J · Destroyed NTSB CHI68D0657Accident · No injuriesClosedCessna 150 · Strongsville, OHFeb 25, 1968 · N4728X · Substantial damage NTSB CHI68D0504Accident · No injuriesClosedCessna 150 · Mansfield, OHNov 8, 1967 · N6209S · Substantial damage NTSB CHI68F0191Accident · Serious injuriesClosedCessna 150 · Waynesville, OHJul 26, 1967 · N6248S · Substantial damage NTSB CHI67F0329Accident · No injuriesClosedCessna 150 · Strongsville, OHOct 12, 1966 · N3683J · Substantial damage NTSB CHI67D0273Accident · No injuriesClosedCessna 150 · Middle Bass, OHSep 10, 1966 · N4734X · Destroyed