NTSB investigations: Cessna 150L, NV

9 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

NTSB investigations: Cessna 150L, NV per year, 1971–2026: 9 cases
1971	2
1981	1
1983	1
1984	1
1987	1
1992	1
1994	1
1998	1

Where

Open the map

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" = 'NV' 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\" = 'NV' 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" = 'NV' 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 LAX99FA027Accident · 3 fatalField investigationFinal reportCessna 150L · Yerington, NVthe failure of the pilot to see and avoid the aircraft ahead, which was already established in the traffic pattern. The failure of both pilots announce their intentions on the Common Traffic Advisory Frequency was a factor in this accident.Nov 12, 1998 · N19281 · 2 aircraft · Destroyed NTSB LAX95LA061Accident · No injuriesLimited investigationFinal reportCessna 150L · North Las Vegas, NVthe pilot's improper in-flight planning and decisions, and his failure to initiate remedial actions in a timely fashion.Dec 27, 1994 · N7446G · Substantial damage NTSB LAX92LA180Accident · No injuriesLimited investigationFinal reportCessna 150 · Mesquite, NVThe pilot's poor preflight planning and improper fuel consumption calculations. Factors relating to this accident were fuel exhaustion, and the unsuitable terrain, and lack of understanding of the airplane's fuel system.Apr 19, 1992 · N6582G · Substantial damage NTSB SEA87LA065Accident · No injuriesLimited investigationFinal reportCessna 150 · Las Vegas, NVDuring landing a gust of wind occurred from the right. The student pilot was not able to correct for the wind and lost control of the aircraft. The aircraft veered to the left of the runway onto rough terrain and then nosed over inverted.Mar 18, 1987 · N457AF · Substantial damage NTSB SEA84LA129Accident · No injuriesLimited investigationFinal reportCessna 150L · Reno, NVAs the student plt was flaring to land, the acft ballooned & subsequently entered a porpoise. He attempted to make a go-around, but the acft struck the ground when it lost altitude after the student retracted the flaps.Jun 12, 1984 · N21939 · Substantial damage NTSB LAX83LA460Accident · No injuriesLimited investigationFinal reportCessna 150 · Sparks, NVThe stu plt stated he encountered wind shear on short final and applied full pwr but the nose wheel struck a dirt bank at the rwy threshold. The acft bounced back into the air and came down on the rwy at which time the nose gear departed the acft as it slid…Sep 11, 1983 · N11491 · Substantial damage NTSB LAX81FA066Accident · 1 fatalClosedCessna 150L · Reno, NVMar 24, 1981 · N19517 · Destroyed NTSB LAX72AL028Accident · 1 fatalClosedCessna 150 · Reno, NVOct 25, 1971 · N6874G · Destroyed NTSB OAK71AP046Accident · 2 fatalClosedCessna 150 · Minden, NVMay 16, 1971 · N6663G · Destroyed