Skip to content

NTSB investigations: Cessna 150F, IN

38 cases on aircraft the registry lists as Cessna 150F. 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" = 'IN' 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 ('2071814')) 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\" = 'IN' 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 ('2071814'))
  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" = 'IN' 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 ('2071814'))
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 CEN18TA233Accident · Serious injuriesFinal reportCessna 150F · Ferdinand, INThe pilot's failure to apply carburetor heat in conditions conducive to the accumulation of carburetor icing, which resulted in a total loss of engine power.Jun 19, 2018 · N3002X · Substantial damage NTSB CEN16FA216Accident · 2 fatalField investigationFinal reportCessna 150F · Rockville, INThe pilot's use of an improper soft-field takeoff procedure, which resulted in the airplane having insufficient airspeed to climb out of ground effect and its subsequent impact with trees near the departure end of the runway.Jun 13, 2016 · N102DK · Destroyed NTSB CEN15LA433Accident · Serious injuriesLimited investigationFinal reportCessna 150F · Fort Wayne, INThe pilot's inadequate preflight planning and fuel management, which resulted in a total loss of engine power due to fuel exhaustion.Sep 26, 2015 · N6922F · Substantial damage NTSB CHI02LA190Accident · No injuriesLimited investigationFinal reportCessna 150F · Ft. Wayne, INThe corroded throttle cable resulting in a loss of engine power. Factors were the inadequate annual inspection, the unsuitable terrain encountered during the forced landing, the ditch, and the fence.Jul 10, 2002 · N8798S · Substantial damage NTSB CHI97FA208Accident · 1 fatalField investigationFinal reportCessna 150F · Gary, INthe pilot's not obtaining/maintaining airspeed which resulted in a stall.Jul 12, 1997 · N8197S · Destroyed NTSB CHI97LA089Accident · No injuriesLimited investigationFinal reportCessna 150 · Petersburg, INThe pilot's failure to maintain adequate airspeed, which resulted in a stall. Low altitude flight is a contributing factor.Mar 23, 1997 · N8196S · Substantial damage NTSB CHI90LA059Accident · No injuriesLimited investigationFinal reportCessna 150F · Elkhart, INFailure of the pilot to maintain directional control of the aircraft, which resulted in his failure to maintain proper runway alignment. Factors related to the accident were the pilot's lack of experience in winter operations, the icy runway condition, and…Jan 1, 1990 · N8575G · Substantial damage NTSB CHI86FEX09Accident · Serious injuriesFinal reportCessna 150F · Marion, INThe plt rprtd that while circling around farm fields, he entered a turn & was looking behind the acft when it entered a power-on stall, then began to spin. Rprtdly, the acft was in a nose high attitude when it stalled. The plt stopped the rotation & was…Jul 4, 1986 · N8602G · Destroyed NTSB CHI80FEX25Accident · No injuriesClosedCessna 150F · Jeffersonville, INJul 20, 1980 · N7988F · Substantial damage NTSB CHI78FET15Accident · No injuriesClosedCessna 150E · Huntington, INMar 18, 1978 · N7701F · Substantial damage NTSB CHI78DEX04Accident · No injuriesClosedCessna 150 · Noblesville, INNov 4, 1977 · N7964F · Substantial damage NTSB CHI75DET04Accident · No injuriesClosedCessna 150 · Hobart, INJul 31, 1974 · N6466F · Substantial damage NTSB CHI73DEA40Accident · No injuriesClosedCessna 150F · Mc Cordsville, INJun 24, 1973 · N6427F · Substantial damage NTSB CHI72AC093Accident · 1 fatalClosedCessna 150F · Fort Wayne, INMay 17, 1972 · N8310G · Destroyed NTSB CHI72DEA27Accident · No injuriesClosedCessna 150 · Lebanon, INJan 8, 1972 · N8098F · Substantial damage NTSB CHI71DBA26Accident · No injuriesClosedCessna 150F · Greentown, INJan 21, 1971 · N8602G · Substantial damage NTSB CHI70FBM01Accident · No injuriesClosedCessna 150F · Ossian, INJan 19, 1970 · N8333G · Substantial damage NTSB CHI70D0250Accident · No injuriesClosedCessna 150 · Romney, INSep 21, 1969 · N8309G · Substantial damage NTSB CHI70D0231Accident · No injuriesClosedCessna 150F · Elkhart, INAug 16, 1969 · N6718F · Substantial damage NTSB CHI70D0115Accident · No injuriesClosedCessna 150H · Marion, INJul 3, 1969 · N6427F · Substantial damage NTSB CHI69D0664Accident · No injuriesClosedCessna 150 · Crawfordsvlle, INApr 26, 1969 · N6450F · Substantial damage NTSB CHI69D0601Accident · No injuriesClosedCessna 150 · Ft Wayne, INApr 11, 1969 · N8394G · Substantial damage NTSB CHI69D0599Accident · No injuriesClosedCessna 150 · Hobart, INMar 30, 1969 · N8288S · Substantial damage NTSB CHI69A0074Accident · Serious injuriesClosedCessna 150 · Vincennes, INFeb 17, 1969 · N7868F · 2 aircraft · Minor damage NTSB CHI69F0232Accident · No injuriesClosedCessna 150F · Elkhart, INAug 11, 1968 · N6718F · Substantial damage NTSB CHI69F0166Accident · No injuriesClosedCessna 150 · La Porte, INAug 4, 1968 · N7814F · Destroyed NTSB CHI68F0655Accident · No injuriesClosedCessna 150F · Plymouth, INMar 24, 1968 · N6561F · Substantial damage NTSB CHI68F0554Accident · No injuriesClosedCessna 150 · Elkhart, INJan 16, 1968 · N6718F · Substantial damage NTSB CHI68D0532Accident · No injuriesClosedCessna 150 · Vincennes, INJan 7, 1968 · N379VU · Substantial damage NTSB CHI68F0338Accident · No injuriesClosedCessna 150 · Fort Wayne, INSep 25, 1967 · N8394G · Substantial damage NTSB CHI67F0624Accident · No injuriesClosedCessna 150F · Fort Wayne, INApr 28, 1967 · N8394G · Substantial damage NTSB CHI67D0619Accident · No injuriesClosedCessna 150 · Fort Wayne, INApr 4, 1967 · N8232F · Substantial damage NTSB CHI67D0153Accident · No injuriesClosedCessna 150 · Bloomington, INJul 30, 1966 · N8289F · Substantial damage NTSB CHI67D0104Accident · No injuriesClosedCessna 150 · Indianapolis, INJul 10, 1966 · N6518F · Substantial damage NTSB CHI66D0648Accident · No injuriesClosedCessna 150 · Terre Haute, INFeb 26, 1966 · N6427F · Substantial damage NTSB CHI66D0524Accident · No injuriesClosedCessna 150 · Terre Haute, INJan 14, 1966 · N8534G · Substantial damage NTSB CHI66A0058Accident · 1 fatalClosedCessna 150F · South Bend, INDec 10, 1965 · N8072S · Destroyed NTSB CHI66F0430Accident · No injuriesClosedCessna 172 · Fort Wayne, INNov 1, 1965 · N7227T · 2 aircraft · Substantial damage