Skip to content

NTSB investigations: Cessna 150F, AR

26 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" = 'AR' 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\" = 'AR' 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" = 'AR' 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 DFW05LA092Accident · Serious injuriesLimited investigationFinal reportCessna 150F · Tontitown, ARThe pilot's falure to maintain airspeed which resulted in an inadvertent stall. A contributing factor was the prevailing tailwind.Mar 20, 2005 · N6828F · Substantial damage NTSB FTW98FA365Accident · 1 fatalField investigationFinal reportCessna 150F · Wilton, ARThe pilot's failure to maintain minimum required airspeed for flight, which resulted in an inadvertent stall. Factors were the pilot's improper use of flaps during the takeoff climb and the high density altitude.Aug 20, 1998 · N7738F · Substantial damage NTSB FTW95LA346Accident · No injuriesLimited investigationFinal reportCessna 150F · Manila, ARA blown (tripped) fuse, which rendered flap retraction inoperative. Factors relating to the accident were: the hot weather condition, the aircraft's lack of climb performance with the flaps extended, and the lack of suitable terrain in the forced landing area.Aug 16, 1995 · N8905S · Substantial damage NTSB FTW93LA004Accident · No injuriesLimited investigationFinal reportCessna 150F · Hughes, ARThe loss of control during the landing roll. A factor was the partial loss of engine power.Oct 2, 1992 · N8119F · Substantial damage NTSB MKC88LA152Accident · No injuriesLimited investigationFinal reportCessna 150 · Coy, ARWhile practicing for his pvt plt check ride, the student pilot returned to the airstrip to practice takeoffs and ldgs. He lost all power on final approach, and due to aircraft on the departure end of the runway, he attempted an emergency ldg on an adjacent…Aug 7, 1988 · N8697S · Substantial damage NTSB MKC88LA002Accident · No injuriesLimited investigationFinal reportCessna 150 · Hope, ARDuring tkof from a private 1500 foot airstrip the student plt stated that the acft would not climb and began to settle. He realized he was losing airspeed and did not have enough altitude to trade for airspeed so he chopped the throttle and made an emergency…Oct 6, 1987 · N8940S · Substantial damage NTSB MKC87LA151Accident · No injuriesLimited investigationFinal reportCessna 150F · Bono, ARThe pilot said he had glided down to 500 feet AGL with the throttle reduced to idle trying to locate a landing strip. He said he applied power and the engine responded too late to avoid hitting a levee in the rice field and he flipped to the inverted position.Jul 31, 1987 · N8591G · Substantial damage NTSB FTW83LA007Accident · Minor injuriesLimited investigationFinal reportCessna 150F · Pine Bluff, ARThe student pilot had made several touch-and-go landings on the same runway. He stated his last approach and touchdown were normal. Reportedly, the nose gear collapsed during the landing roll. The aircraft went off the left side of the runway and flipped…Oct 1, 1982 · N8119F · Substantial damage NTSB FTW82FPG69Accident · Minor injuriesClosedCessna 150F · England, ARSep 29, 1981 · N8039F · Substantial damage NTSB FTW79DPG08Accident · No injuriesClosedCessna 150F · Mt.Ida, ARNov 5, 1978 · N2200W · Substantial damage NTSB FTW76FPH14Accident · Serious injuriesClosedCessna 150 · Searcy, ARSep 21, 1976 · N6936F · Destroyed NTSB FTW76FPG73Accident · Minor injuriesClosedCessna 150 · Hot Springs, ARJul 4, 1976 · N6963F · Substantial damage NTSB FTW76FPG39Accident · Serious injuriesClosedCessna 150F · Monticello, ARDec 26, 1975 · N6447F · Destroyed NTSB FTW74FRD12Accident · No injuriesClosedCessna 150 · Loreauville, ARSep 13, 1973 · N8983S · Substantial damage NTSB FTW73FPG40Accident · Serious injuriesClosedCessna 150F · Conway, ARMar 8, 1973 · N8218S · Substantial damage NTSB FTW73DRJ12Accident · No injuriesClosedCessna 150F · Texarkana, ARSep 3, 1972 · N6639F · Substantial damage NTSB FTW69F0121Accident · No injuriesClosedCessna 150F · Jacksonville, ARAug 15, 1968 · N8818S · Substantial damage NTSB FTW69F0073Accident · No injuriesClosedCessna 150 · Jacksonville, ARMay 14, 1968 · N8818S · Substantial damage NTSB FTW68D0499Accident · No injuriesClosedCessna 150 · Conway, ARMar 18, 1968 · N8584G · Substantial damage NTSB FTW68F0445Accident · Minor injuriesClosedCessna 150 · Marshall, ARFeb 4, 1968 · N8145F · Substantial damage NTSB FTW68F0231Accident · No injuriesClosedCessna 150F · Tinsman, ARSep 2, 1967 · N8545G · Substantial damage NTSB FTW68D0056Accident · No injuriesClosedCessna 150 · Morrilton, ARJun 24, 1967 · N7187F · Substantial damage NTSB FTW67D0499Accident · No injuriesClosedCessna 150 · Blytheville, ARMar 19, 1967 · N8025S · Substantial damage NTSB FTW67D0262Accident · No injuriesClosedCessna 150 · Rogers, AROct 15, 1966 · N7852F · Substantial damage NTSB FTW66D0521Accident · No injuriesClosedCessna 150 · Hot Springs, ARFeb 17, 1966 · N8818S · Substantial damage NTSB FTW66A0047Accident · 1 fatalClosedCessna 150F · Holly Grove, ARNov 19, 1965 · N3503L · Destroyed