Skip to content

NTSB investigations: Cessna 150L, AR

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

19732026

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 ('2071826')) 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 ('2071826'))
  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 ('2071826'))
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 CEN22LA024Accident · 1 fatalClass 3 · LimitedFinal reportCessna 150L · Forrest City, ARThe pilot’s loss of control during landing. Contributing to the pilot’s injuries was his ejection from the airplane resulting from him not wearing his available seat restraints.Oct 31, 2021 · N6713G · Substantial damage NTSB CHI03LA323Accident · No injuriesLimited investigationFinal reportCessna 150L · Siloam Springs, ARA loss of engine power due to the pilot's inadequate planning/decision resulting in fuel exhaustion. Factors were the trees and the night conditions.Sep 28, 2003 · N21915 · Substantial damage NTSB CHI03LA245Accident · No injuriesLimited investigationFinal reportCessna 150L · Pine Bluff, ARInadequate preflight planning which resulted in fuel exhaustion during the cross country flight. A factor associated with the accident was the rough terrain encountered during the forced landing.Aug 2, 2003 · N6791G · Substantial damage NTSB FTW01LA001Accident · No injuriesLimited investigationFinal reportCessna 150L · Nashville, ARThe pilot's failure to refuel resulting in loss of engine power due to fuel exhaustion. A factor was the lack of suitable terrain for the forced landing.Oct 1, 2000 · N11390 · Substantial damage NTSB FTW98LA147Accident · No injuriesLimited investigationFinal reportCessna 150L · Conway, ARThe pilot's improper landing flare which resulted in a hard landing and her improper recovery procedures for a bounced landing.Mar 13, 1998 · N21915 · Substantial damage NTSB FTW92LA065Accident · No injuriesLimited investigationFinal reportCessna 150L · Searcy, ARThe pilot's improper use of carburetor heat resulting in the loss of engine power due to carburetor ice. The carburetor icing conditions and the soft terrain in the landing area were factors.Feb 2, 1992 · N11567 · Substantial damage NTSB MKC87LA108Accident · No injuriesLimited investigationFinal reportCessna 150L · Harrison, ARThe pilot said he was landing into the wind and when he was 20 feet above the runway, the wind seemed to shift to a tail wind. The airplane stalled, hit the runway hard and bounced. The pilot said he pushed the control wheel forward and the nose wheel hit the…May 25, 1987 · N1418Q · Substantial damage NTSB MKC85LA209Accident · No injuriesLimited investigationFinal reportCessna 150L · Morrilton, ARThe airplane was on a night flight when the engine failed. During the forced landing, the airplane struck and remained attached to high voltage powerlines. Inspection of the engine revealed number three cylinder cracked and the top compression ring on number…Sep 7, 1985 · N6999G · Substantial damage NTSB FTW80DPG67Accident · No injuriesClosedCessna 150 · Benton, ARSep 8, 1980 · N11485 · Substantial damage NTSB FTW80FPG65Accident · Serious injuriesClosedCessna 150L · Clarksville, ARSep 4, 1980 · N17006 · Substantial damage NTSB FTW79FPG84Accident · No injuriesClosedCessna 150L · Cass, ARSep 30, 1979 · N10734 · Substantial damage NTSB FTW79DPG09Accident · No injuriesClosedCessna 150 · Benton, ARNov 19, 1978 · N11485 · Substantial damage NTSB FTW77FPG22Accident · No injuriesClosedCessna 150L · Pine Bluff, ARMar 25, 1977 · N1716Q · Substantial damage NTSB FTW76DPG29Accident · No injuriesClosedCessna 150 · Rye, AROct 11, 1975 · N11485 · Substantial damage NTSB FTW76DPG21Accident · No injuriesClosedCessna 150 · Van Buren, ARSep 6, 1975 · N10734 · Substantial damage NTSB FTW76DPG17Accident · No injuriesClosedCessna 150 · Mountain View, ARAug 20, 1975 · N19068 · Substantial damage NTSB FTW75FPG82Accident · Serious injuriesClosedCessna 150 · No.Little Rock, ARJun 13, 1975 · N18512 · Destroyed NTSB FTW75FPG52Accident · Serious injuriesClosedCessna 150L · Greenwood, ARMay 10, 1975 · N19395 · Destroyed NTSB FTW75DPG37Accident · No injuriesClosedCessna 188 · Widner, ARMar 21, 1975 · N6523G · Substantial damage NTSB FTW75AF022Accident · 2 fatalClosedCessna 150L · Parkin, ARSep 19, 1974 · N11958 · Destroyed NTSB FTW75DPG05Accident · Minor injuriesClosedCessna 150 · Springdale, ARJul 22, 1974 · N5416Q · Substantial damage NTSB FTW74FPG28Accident · No injuriesClosedCessna 150L · Joiner, AROct 2, 1973 · N18155 · 2 aircraft · Substantial damage