Skip to content

NTSB investigations: Cessna 150L, AZ

28 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

19712026

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" = 'AZ' 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\" = 'AZ' 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" = 'AZ' 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 LAX08LA077Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Mesa, AZA partial loss of engine power for undetermined reasons.Mar 18, 2008 · N19521 · Substantial damage NTSB LAX02LA025Accident · Serious injuriesLimited investigationFinal reportCessna 150L · Nogales, AZThe pilot failed to maintain directional control while landing in a cross wind. He attempted a go-around, but inadvertently stalled the airplane, which resulted in an uncontrolled descent and collision with the runway.Nov 10, 2001 · N10680 · Substantial damage NTSB LAX98LA016Accident · No injuriesLimited investigationFinal reportCessna 150 · Temple Bar, AZthe pilot's improper planning/decision, which resulted in fuel exhaustion and loss of engine power. A factor relating to the accident was: the terrain condition (ditch) in the emergency landing area.Oct 13, 1997 · N71VL · Substantial damage NTSB LAX97LA129Accident · No injuriesLimited investigationFinal reportCessna 150L · Nogales, AZLoss of engine power due to fuel contamination resulting from the pilot's inadequate fuel storage and filtering procedures.Mar 21, 1997 · N21993 · Substantial damage NTSB LAX96LA088Accident · No injuriesLimited investigationFinal reportCessna 150L · Quartzite, AZthe pilot's misjudgement of his distance and altitude relationship to the runway, which resulted in an undershoot and failure to achieve the proper touchdown point for landing.Dec 29, 1995 · N1246Q · Substantial damage NTSB LAX94LA140Accident · No injuriesLimited investigationFinal reportCessna 150 · Chandler, AZThe pilot's intentional swerve to avoid a large bird that flew toward the airplane during the landing roll.Feb 27, 1994 · N10669 · Substantial damage NTSB LAX92LA243Accident · No injuriesLimited investigationFinal reportCessna 150 · Tucson, AZThe pilot's failure to follow v.f.r. procedures; inadequate preflight planning/preperation; and improper fuel consumption calculations which resulted in fuel exhaustion.Jun 12, 1992 · N6972G · Substantial damage NTSB LAX90LA086Accident · No injuriesLimited investigationFinal reportCessna 150L · Bullhead City, AZThe pilot's miscalculation of the fuel remaining, which caused the engine to quit.Feb 10, 1990 · N1272Q · Substantial damage NTSB LAX90LA011Accident · No injuriesLimited investigationFinal reportCessna 150L · Marana, AZFailure of the pilot to properly judge his fuel supply, which resulted in fuel exhaustion.Oct 25, 1989 · N642EZ · Substantial damage NTSB LAX86LA094Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Cottonwood, AZThe acft had not been flown for about 4 yrs. The plt intended to fly it to chandler, AZ, for an annual inspn. The pax stated the plt had previously made a test flt, but had a problem starting the eng. Rprtdly, the plt 'cleaned the fuel system and filled the…Jan 18, 1986 · N21995 · Substantial damage NTSB LAX84LA321Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Benson, AZStudent pilot was on a crosscountry when she became lost. Efforts were made to establish her position by contacting air traffic control on the emergency radio frequency. By the time her position was established the aircraft was about out of fuel. The pilot…May 28, 1984 · N242EZ · Substantial damage NTSB LAX81DUJ97Accident · No injuriesClosedCessna 150 · Douglas, AZAug 24, 1981 · N10896 · Substantial damage NTSB LAX81DUJ69Accident · No injuriesClosedCessna 150L · Bullhead City, AZJun 18, 1981 · N19058 · Substantial damage NTSB LAX79DUK08Accident · No injuriesClosedCessna 150 · Marana, AZJul 28, 1979 · N11841 · Substantial damage NTSB LAX79DUJ96Accident · Minor injuriesClosedCessna 150 · Yuma, AZJul 24, 1979 · N1456Q · Substantial damage NTSB LAX77DUJ20Accident · No injuriesClosedCessna 150 · Winslow, AZJan 19, 1977 · N11819 · Substantial damage NTSB LAX77FUJ11Accident · Minor injuriesClosedCessna 150 · Mesa, AZDec 8, 1976 · N5433Q · Substantial damage NTSB LAX76DWJ25Accident · No injuriesClosedCessna 150 · Seligman, AZSep 15, 1975 · N16094 · Substantial damage NTSB LAX76AL013Accident · 1 fatalClosedCessna 150L · Camp Verde, AZAug 23, 1975 · N1383Q · Substantial damage NTSB LAX75FUJ66Accident · No injuriesClosedCessna 150L · Wikieup, AZMar 23, 1975 · N17034 · Substantial damage NTSB LAX75DUJ10Accident · Minor injuriesClosedCessna 150 · Chandler, AZJul 13, 1974 · N11941 · Substantial damage NTSB LAX75FUJ04Accident · No injuriesClosedCessna 150 · Page, AZJul 7, 1974 · N10940 · Substantial damage NTSB LAX74DUJ62Accident · No injuriesClosedCessna 150 · Tucson, AZMay 15, 1974 · N21928 · Substantial damage NTSB LAX74DUJ50Accident · No injuriesClosedCessna 150 · Phoenix, AZMar 30, 1974 · N18670 · Substantial damage NTSB LAX74FUJ33Accident · No injuriesClosedCessna 150L · Florence, AZNov 20, 1973 · N1613Q · Substantial damage NTSB LAX74FUJ25Accident · 1 fatalClosedCessna 150 · Scottsdale, AZSep 28, 1973 · N1361Q · Destroyed NTSB LAX73DUJ77Accident · Minor injuriesClosedCessna 150 · Glendale, AZApr 7, 1973 · N6568G · Substantial damage NTSB LAX71AL052Accident · 1 fatalClosedCessna 150 · Phoenix, AZFeb 18, 1971 · N6541G · Destroyed