Skip to content

NTSB investigations: Cessna 150M, AR

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

19762026

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 ('2071830')) 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 ('2071830'))
  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 ('2071830'))
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 DFW08LA161Accident · 1 fatalLimited investigationFinal reportCessna 150M · Forrest City, ARThe failure of the pilot to maintain adequate airspeed while maneuvering in the traffic pattern, resulting in an inadvertent aerodynamic stall.Jun 7, 2008 · N3266V · Substantial damage NTSB FTW04LA180Accident · No injuriesLimited investigationFinal reportCessna 150M · Sherrill, ARthe pilot's inadequate in-flight planning/decision which resulted in the loss of engine power due to fuel exhaustion.Jul 9, 2004 · N8959U · Substantial damage NTSB FTW99LA185Accident · No injuriesLimited investigationFinal reportCessna 150M · Pocahontas, ARThe failure of the carburetor heat control cable which resulted in a partial loss of engine power during initial takeoff climb. A factor was the lack of suitable terrain for the forced landing.Jul 7, 1999 · N7660U · Substantial damage NTSB FTW96LA209Accident · No injuriesLimited investigationFinal reportCessna 150M · Springdale, ARthe flight instructor's improper (unapproved) procedure of using the mixture control to simulate an engine failure. A factor relating to the accident was: the lack of suitable terrain for a forced landing.May 11, 1996 · N704RS · Substantial damage NTSB FTW95FA337Accident · 2 fatalField investigationFinal reportCessna 150M · Armorel, ARThe pilot's impairment of judgement and performance due to drugs which led to his failure to maintain airspeed and resulted in an inadvertent stall/spin. Factors were the pilot's overconfidence in personal ability and interpersonal relations.Aug 12, 1995 · N714FX · Destroyed NTSB FTW93LA224Accident · No injuriesLimited investigationFinal reportCessna 150M · Bald Knob, ARFuel exhaustion due to the pilot's failure to refuel. A factor was the lack of suitable terrain for the forced landing.Aug 1, 1993 · N66081 · Substantial damage NTSB FTW91LA133Accident · No injuriesLimited investigationFinal reportCessna 150 · Searcy, ARThe pilots misjudgment of altitude and lack of a timely flare.Jul 24, 1991 · N7655U · Substantial damage NTSB MKC90LA053Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Palestine, ARImproper planning/decision by the pilot, which resulted in fuel exhaustion, due to an inadequate supply of fuel.Feb 10, 1990 · N3049V · Substantial damage NTSB MKC90LA015Accident · No injuriesLimited investigationFinal reportCessna 150 · Cherokee Vill, ARThe pilots failure to use carburetor heat properly. Contributing to the accident were the carburetor icing conditions.Oct 23, 1989 · N704SZ · Substantial damage NTSB MKC87LA086Accident · No injuriesLimited investigationFinal reportCessna 150 · West Memphis, ARThe acft was flown 1.6 hrs on a previous flt since being topped off with fuel. At the end of 2 hrs and 11 mins, during the accident flt, the eng quit. The fuel tanks were found to be empty with no broken fuel lines. During the post accident exam, it was found…Apr 21, 1987 · N704UU · Substantial damage NTSB FTW80FPG13Accident · Serious injuriesClosedCessna 150M · Burlington, ARFeb 19, 1980 · N714KJ · Destroyed NTSB FTW80DPG12Accident · No injuriesClosedCessna 150 · Texarkana, ARFeb 2, 1980 · N45490 · Substantial damage NTSB FTW78DPG80Accident · No injuriesClosedCessna 150 · Springdale, ARAug 24, 1978 · N9320U · Substantial damage NTSB FTW77DPG25Accident · No injuriesClosedCessna 150 · N.Little Rock, ARApr 14, 1977 · N63290 · Substantial damage NTSB FTW77DPG13Accident · No injuriesClosedCessna 150 · Mt.Home, ARDec 24, 1976 · N66094 · Substantial damage NTSB FTW76FRJ26Accident · No injuriesClosedCessna 150M · Texarkana, ARMay 19, 1976 · N45547 · Substantial damage