Skip to content

NTSB investigations: Cessna 150F, AZ

30 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

19662026

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 ('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\" = '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 ('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" = '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 ('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 WPR25LA305Accident · Minor injuriesClass 3 · LimitedPreliminary reportCessna 150F · Lake Havasu City, AZOn September 26, 2025, at about 0915 mountain standard time, a Cessna 150F, N8171S, was substantially damaged when it was involved in an accident near Lake Havasu City, Arizona. The flight instructor and student pilot sustained minor injuries. The airplane…Sep 26, 2025 · N8171S · Substantial damage NTSB WPR21LA038Accident · No injuriesClass 4 · LimitedFinal reportCessna 150F · Chandler, AZThe pilot’s inadequate preflight inspection and fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.Nov 6, 2020 · N8700G · Substantial damage NTSB LAX06LA029Accident · Minor injuriesLimited investigationFinal reportCessna 150F · Mesa, AZthe failure of the flap motor fuse that rendered the flaps inoperable during a critical phase of flight. Factors in the accident were the lack of suitable terrain to perform an emergency landing and the owner's use of nonapproved fuses for the flap motor…Nov 8, 2005 · N8903S · Substantial damage NTSB LAX05LA138Accident · No injuriesLimited investigationFinal reportCessna 150F · Prescott, AZthe pilot's failure to maintain directional control on landing.Apr 15, 2005 · N8324G · Substantial damage NTSB LAX97LA256Accident · No injuriesLimited investigationFinal reportCessna 150F · Casa Grande, AZFailure of the student pilot to maintain directional control.Jun 28, 1997 · N6634F · Substantial damage NTSB LAX89LA017Accident · No injuriesLimited investigationFinal reportCessna 150F · Goodyear, AZThe plt rprtd that drg the landing roll, the acft enctrd a gust of wind & veered off the dirt strip & onto a raised berm (edge of rwy). After enctrg the soft dirt & rough terrain, the nose gear collapsed & the plane nosed over. The plt had landed with 40 deg…Oct 18, 1988 · N8194F · Substantial damage NTSB LAX88LA217Accident · 1 fatalLimited investigationFinal reportCessna 150F · Quartzsite, AZJun 8, 1988 · N7892F · Substantial damage NTSB LAX85LA072Accident · No injuriesLimited investigationFinal reportCessna 150F · Glendale, AZThe acft lost power & nosed over while making an emergency landing in a muddy field. Investigation revealed that fuel was being siphoned from the fuel tank vent.Dec 15, 1984 · N7967F · Substantial damage NTSB LAX84LA133Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Sedona, AZThe acft landed short of the rwy during an emergency landing. The plt said the acft ran out of fuel about 1 mile from the arpt at 6200 ft MSL. He said he miscalculated the fuel consumption due to head winds.Jan 4, 1984 · N8300G · Substantial damage NTSB LAX81FUJ51Accident · No injuriesClosedCessna 150 · Globe, AZApr 20, 1981 · N8870S · Destroyed NTSB LAX80DUJ41Accident · No injuriesClosedCessna 150 · Sedona, AZDec 12, 1979 · N3575L · Substantial damage NTSB LAX79FUJ64Accident · No injuriesClosedCessna 150 · Willcox, AZApr 22, 1979 · N8204F · Substantial damage NTSB LAX77DUJ16Accident · No injuriesClosedCessna 150 · Bagdad, AZDec 28, 1976 · N6682F · Destroyed NTSB LAX76FUJ95Accident · No injuriesClosedCessna 150F · Springerville, AZJul 31, 1976 · N8434G · Substantial damage NTSB LAX74AL073Accident · 2 fatalClosedCessna 150F · Chandler, AZMay 12, 1974 · N3112X · Destroyed NTSB LAX74DUJ43Accident · No injuriesClosedCessna 150 · Roosevelt, AZFeb 18, 1974 · N6755F · Destroyed NTSB LAX72DUJ62Accident · No injuriesClosedCessna 150F · Litchfld Pk, AZDec 4, 1971 · N8355G · Substantial damage NTSB LAX71DUJ02Accident · No injuriesClosedCessna 150 · Cottonwood, AZJul 7, 1970 · N8840S · Substantial damage NTSB LAX70AL073Accident · 1 fatalClosedCessna 150F · New River, AZJun 14, 1970 · N8823G · Destroyed NTSB LAX70AL063Accident · Serious injuriesClosedCessna 150F · Tucson, AZApr 9, 1970 · N6811F · 2 aircraft · Destroyed NTSB LAX69F0270Accident · 1 fatalClosedCessna 150 · Davis Monthn, AZJan 16, 1969 · N6858F · Destroyed NTSB LAX69A0037Accident · 2 fatalClosedCessna 150F · Globe, AZDec 20, 1968 · N8288F · Destroyed NTSB LAX69D0250Accident · No injuriesClosedCessna 150 · Havasu City, AZDec 17, 1968 · N8319G · Substantial damage NTSB LAX69D0208Accident · No injuriesClosedCessna 150 · Holbrook, AZNov 10, 1968 · N8233S · Substantial damage NTSB LAX69D0028Accident · No injuriesClosedCessna 150 · Scottsdale, AZJun 9, 1968 · N7892F · Substantial damage NTSB LAX68F0389Accident · No injuriesClosedCessna 150 · Phoenix, AZMar 31, 1968 · N8296S · Substantial damage NTSB LAX68D0163Accident · No injuriesClosedCessna 150 · Florence Jct, AZSep 4, 1967 · N8674G · Substantial damage NTSB LAX68D0122Accident · No injuriesClosedCessna 150 · Snowflake, AZAug 19, 1967 · N6682F · Substantial damage NTSB LAX68A0011Accident · 2 fatalClosedCessna 150F · Kingman, AZJul 24, 1967 · N8243S · Destroyed NTSB DEN66D0270Accident · No injuriesClosedCessna 150 · Phoenix, AZMar 9, 1966 · N8087S · Substantial damage