Skip to content

NTSB investigations: Cessna 150H, OH

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

19682026

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 ('2071818')) 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 ('2071818'))
  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 ('2071818'))
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 NYC02LA087Accident · No injuriesLimited investigationFinal reportCessna 150H · Smithville, OHThe pilot's failure to maintain directional control. A factor was the gusty windsApr 19, 2002 · N502MA · Substantial damage NTSB BFO94LA068Accident · No injuriesLimited investigationFinal reportCessna 150H · Mount Vernon, OHThe pilot's failure to maintain adequate airspeed, which resulted in an aerodynamic stall and collision with the ground. Factors were transmission wires and the pilot's inadequate inflight decision.Apr 17, 1994 · N22601 · Substantial damage NTSB NYC93LA031Accident · Serious injuriesLimited investigationFinal reportCessna 150H · Mt. Gilead, OHPilot incapacitation due to carbon monoxide gas as a result of cracks in the heater muffler. A factor in the accident was the progressive deterioration of the left heater muffler.Oct 31, 1992 · N6402S · Substantial damage NTSB ATL88FA088Accident · 1 fatalField investigationFinal reportCessna 150H · Youngstown, OHFeb 9, 1988 · N618DP · Substantial damage NTSB ATL87DEG02Accident · No injuriesFinal reportCessna 150H · Harrison, OHThe engine quit after takeoff at about 200 ft AGL. A ldg was made in a plowed field where the acft flipped over inverted. The CFI PIC reported that, prior to takeoff, he had calculated there was adequate fuel on board for the flt; his calculations were based…Dec 27, 1986 · N7190S · Substantial damage NTSB CHI86FEI02Accident · Serious injuriesFinal reportCessna 150H · Strongsville, OHDuring preflight, the student pilot noticed water in the fuel tank when he checked the fuel drain. He notified his instructor, but no further action was taken. Shortly after takeoff the engine quit. An emergency landing was performed in a parking lot and one…Jan 24, 1986 · N22755 · Substantial damage NTSB CHI83LA278Accident · Minor injuriesLimited investigationFinal reportCessna 150H · Germantown, OHThe acft struck a fence during takeoff. The plt said he rotated too soon and was unable to remain airborne. When the acft collided with the fence it cartwheeled, resulting in engine separation and near separation of the empennage. The wind was reported as…Jun 24, 1983 · N22521 · Destroyed NTSB CHI81FA056Accident · 1 fatalClosedCessna 150H · Jasper, OHMay 24, 1981 · N22303 · Destroyed NTSB CHI81FEG08Accident · Minor injuriesClosedCessna 150H · Springboro, OHFeb 25, 1981 · N50199 · Substantial damage NTSB CHI81FEI10Accident · Minor injuriesClosedCessna 150H · Youngstown, OHJan 19, 1981 · N23361 · Substantial damage NTSB CHI77FEK17Accident · No injuriesClosedCessna 150H · Woodsfield, OHMay 14, 1977 · N23341 · Substantial damage NTSB CHI75FEI35Accident · Minor injuriesClosedCessna 150 · Flushing, OHDec 22, 1974 · N22768 · Substantial damage NTSB CHI75DEG09Accident · No injuriesClosedCessna 150H · Moraine, OHDec 7, 1974 · N50250 · Substantial damage NTSB CHI75AC037Accident · 1 fatalClosedCessna 150H · Medina, OHOct 26, 1974 · N6583S · Substantial damage NTSB CHI74DEG21Accident · No injuriesClosedCessna 150 · Dayton, OHApr 11, 1974 · N7193S · Substantial damage NTSB CHI74DE118Accident · No injuriesClosedCessna 150H · Wadsworth, OHJan 5, 1974 · N22151 · 2 aircraft · Substantial damage NTSB CHI74FEG09Accident · Serious injuriesClosedCessna 150 · Oxford, OHOct 14, 1973 · N23502 · Substantial damage NTSB CHI72DEI32Accident · No injuriesClosedCessna 150 · Medina, OHFeb 7, 1972 · N50004 · Substantial damage NTSB CHI72DEI22Accident · No injuriesClosedCessna 150 · Chagrin Fals, OHDec 4, 1971 · N6967S · Substantial damage NTSB CHI72DEI21Accident · No injuriesClosedCessna 150 · Fremont, OHNov 18, 1971 · N6457S · Substantial damage NTSB CHI72AC038Accident · 1 fatalClosedCessna 150H · Aberdeen, OHOct 12, 1971 · N23477 · Destroyed NTSB CHI72FEI13Accident · Serious injuriesClosedCessna 150H · Sheffield, OHAug 14, 1971 · N6914S · Destroyed NTSB CHI71DGD48Accident · No injuriesClosedCessna 150 · Strongsville, OHMar 21, 1971 · N22755 · Substantial damage NTSB CHI71FGG25Accident · No injuriesClosedCessna 150H · Newark, OHFeb 11, 1971 · N22110 · Substantial damage NTSB CHI71FGD33Accident · Minor injuriesClosedCessna 150H · Akron, OHDec 29, 1970 · N6493S · Substantial damage NTSB CHI71FGA15Accident · Minor injuriesClosedCessna 150 · Xenia, OHDec 15, 1970 · N22818 · Destroyed NTSB CHI71FGA14Accident · No injuriesClosedCessna 150 · Washingtn, OHDec 3, 1970 · N23218 · Substantial damage NTSB CHI71FGD12Accident · No injuriesClosedCessna 150 · Tiffin, OHAug 14, 1970 · N23301 · 2 aircraft · Minor damage NTSB CHI71FGA05Accident · No injuriesClosedCessna 150 · Oxford, OHAug 6, 1970 · N22980 · Substantial damage NTSB CHI70D0059Accident · No injuriesClosedCessna 150H · Columbus, OHJul 13, 1969 · N22305 · Substantial damage NTSB CHI70F0237Accident · Minor injuriesClosedCessna 150H · Lorain, OHJun 22, 1969 · N22878 · Substantial damage NTSB CHI69F0128Accident · No injuriesClosedCessna 150 · Toledo, OHJul 19, 1968 · N22110 · Substantial damage NTSB CHI69F0038Accident · No injuriesClosedCessna 150 · Columbus, OHJun 22, 1968 · N22767 · Substantial damage NTSB CHI69D0020Accident · No injuriesClosedCessna 150 · Chardon, OHJun 3, 1968 · N6709S · Substantial damage NTSB CHI68D0715Accident · No injuriesClosedCessna 150 · Toledo, OHMar 24, 1968 · N22047 · Substantial damage