NTSB investigations: Cessna 150H, NV

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

19682026

NTSB investigations: Cessna 150H, NV per year, 1968–2026: 7 cases
1968	2
1970	1
1972	1
1996	1
1997	1
2003	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 ('2071818')) 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 ('2071818'))
  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 ('2071818'))
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 LAX03LA234Accident · Minor injuriesLimited investigationFinal reportCessna 150H · Dyer, NVthe pilot's inadequate compensation for the gusting crosswind conditions and failure to maintain directional control.Jul 12, 2003 · N22897 · Substantial damage NTSB LAX97LA214Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Jean, NVThe pilot's failure to maintain adequate airspeed which resulted in a stall/mush. Also causal was the pilot's failure to retract the flaps during the go-around.Jun 16, 1997 · N22406 · Destroyed NTSB LAX96LA318Accident · Serious injuriesLimited investigationFinal reportCessna 150H · Minden, NVthe pilot's delayed remedial action when encountering downdrafts while approaching high terrain in high density altitude conditions. The pilot's inadequate supervision of the second pilot was a factor in the accident.Aug 28, 1996 · N788JG · Destroyed NTSB OAK72FVW30Accident · No injuriesClosedCessna 150H · Tonopah, NVMay 14, 1972 · N6931S · Substantial damage NTSB OAK71FXQ06Accident · No injuriesClosedCessna 150 · Reno, NVJul 16, 1970 · N7261S · Substantial damage NTSB OAK69A0026Accident · 2 fatalClosedCessna 150H · Las Vegas, NVOct 29, 1968 · N6655S · Destroyed NTSB OAK69A0004Accident · 1 fatalClosedCessna 150H · N Las Vegas, NVJul 17, 1968 · N22987 · Destroyed