Skip to content

NTSB investigations: Cessna 150G, AZ

27 cases on aircraft the registry lists as Cessna 150G. 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 ('2071816')) 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 ('2071816'))
  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 ('2071816'))
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 WPR26LA150Accident · No injuriesClass 3 · LimitedPreliminary reportCessna 150G · Phoenix, AZOn April 8, 2026, about 1033 mountain standard time, a Cessna 150G, N4714X, was substantially damaged when it was involved in an accident near Phoenix, Arizona. The flight instructor and student pilot were not injured. The airplane was being operated as a…Apr 8, 2026 · N4714X · Substantial damage NTSB WPR23LA031Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 150G · Star Valley, AZThe failure of the No. 1 cylinder exhaust or intake valve which resulted in the partial loss of engine power and subsequent impact with terrain.Nov 11, 2022 · N3131J · Substantial damage NTSB WPR11CA312Accident · No injuriesData collectionFinal reportCessna 150G · Mesa, AZThe pilot's failure to maintain directional control during the go around.Jul 6, 2011 · N2878S · Substantial damage NTSB LAX99LA211Accident · 1 fatalLimited investigationFinal reportCessna 150G · Rimrock, AZThe pilot's failure to attain the proper touchdown point and to maintain airspeed during the aborted landing, resulting in an inadvertent stall. A factor was the pilot's failure to adjust the flaps for the attempted aborted landing in accordance with the…Jun 5, 1999 · N2675J · Substantial damage NTSB LAX95LA116Accident · No injuriesLimited investigationFinal reportCessna 150G · Carefree, AZthe pilot's premature retraction of the flaps and failure to maintain an adequate airspeed during a go-around, which resulted in an inadvertent stall/mush.Feb 20, 1995 · N2688J · Destroyed NTSB LAX83LA162Accident · No injuriesLimited investigationFinal reportCessna 150G · Glendale, AZThe instructor plt (CFI) reported that while the student was practicing a full power climb, the eng began a smooth, but relatively rapid, decrease in power to about idle RPM or less. All attempts to restore power were to no avail. An emergency landing was…Mar 26, 1983 · N6319S · Substantial damage NTSB LAX83LA021Accident · No injuriesLimited investigationFinal reportCessna 150 · Peoria, AZWhile taxiing to the ramp the aircraft's left wing struck a chain link fence causing substantial damage to the aircraft.Oct 3, 1982 · N6319S · Substantial damage NTSB LAX82DUJ41Accident · No injuriesFinal reportCessna 150G · Pima, AZDuring arrival, the pilot entered traffic to land on runway 36. He reported that the wind was from 97 degrees at 10 gusting 15 knots. While landing, he felt the touchdown would be too FAR from the approach end, so he initiated a go-around. The density…Jun 27, 1982 · N2688J · Substantial damage NTSB LAX82DA121Accident · No injuriesFinal reportCessna 150G · Tucson, AZDuring flight, the student pilot heard a loud noise from the engine and landed at a nearby airport. He reported that during the landing, a gust of wind was encountered, the left wing came up and the nose veered left. At that time, the right spindle attachment…Mar 28, 1982 · N4816X · Substantial damage NTSB LAX79DUK06Accident · No injuriesClosedCessna 150 · Sunflower, AZAug 13, 1979 · N3196X · Substantial damage NTSB LAX79DUJ60Accident · No injuriesClosedCessna 150 · Fredonia, AZApr 7, 1979 · N8333J · Substantial damage NTSB LAX79DUJ40Accident · No injuriesClosedCessna 150 · Tucson, AZDec 27, 1978 · N4816X · Substantial damage NTSB LAX78DUJ55Accident · No injuriesClosedCessna 150G · Marana, AZMay 5, 1978 · N2902J · Substantial damage NTSB LAX77DUK01Accident · No injuriesClosedCessna 150 · Roosevelt Lk, AZAug 24, 1977 · N3273J · Substantial damage NTSB LAX76AL057Accident · 1 fatalClosedCessna 150G · Flagstaff, AZFeb 17, 1976 · N3474J · Destroyed NTSB LAX75DUJ84Accident · No injuriesClosedCessna 150 · Seligman, AZMay 16, 1975 · N8316J · Substantial damage NTSB LAX72FUJ01Accident · Minor injuriesClosedCessna 150G · Scottsdale, AZMay 29, 1972 · N3832J · Substantial damage NTSB LAX70D0228Accident · Serious injuriesClosedCessna 150 · Phoenix, AZDec 25, 1969 · N3783J · Substantial damage NTSB LAX70F0133Accident · No injuriesClosedCessna 150 · Phoenix, AZSep 17, 1969 · N8622J · Substantial damage NTSB LAX70F0060Accident · Minor injuriesClosedCessna 150 · Buckeye, AZAug 6, 1969 · N3952J · Substantial damage NTSB LAX70F0027Accident · No injuriesClosedCessna 150G · Mesa, AZJul 2, 1969 · N3695J · Substantial damage NTSB LAX69D0361Accident · No injuriesClosedCessna 150 · Benson, AZMay 8, 1969 · N3691J · Substantial damage NTSB LAX69D0173Accident · No injuriesClosedCessna 150 · Tucson, AZOct 5, 1968 · N8654J · Substantial damage NTSB LAX68D0406Accident · No injuriesClosedCessna 150 · Mesa, AZApr 18, 1968 · N8316J · Substantial damage NTSB LAX68D0100Accident · No injuriesClosedBeech E18S · Phoenix, AZAug 1, 1967 · N301V · 2 aircraft · Substantial damage NTSB LAX67D0422Accident · No injuriesClosedCessna 150 · Phoenix, AZMay 4, 1967 · N8654J · Substantial damage NTSB LAX67F0105Accident · Serious injuriesClosedCessna 150 · Adamana, AZSep 7, 1966 · N3680J · Destroyed