Skip to content

NTSB investigations: Cessna 150L, MS

19 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

19722026

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" = 'MS' 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\" = 'MS' 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" = 'MS' 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 CEN25LA057Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 150L · Meridian, MSThe pilot’s inadequate preflight planning, which resulted in a total loss of engine power due to fuel exhaustion. Contributing to the accident was the flight instructor’s inadequate verification of his student’s preflight planning.Dec 6, 2024 · N5321Q · Substantial damage NTSB MIA95LA193Accident · No injuriesLimited investigationFinal reportCessna 150L · Picayune, MSLoss of engine power due to undetermined reasons.Aug 5, 1995 · N18679 · Substantial damage NTSB MIA95LA191Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Holly Springs, MSThe failure of the pilot-in-command to insure the oil dip stick was secure prior to departure resulting in loss of engine oil, overheating of the engine, and loss of engine power.Aug 2, 1995 · N1774Q · Substantial damage NTSB MIA94LA073Accident · No injuriesLimited investigationFinal reportCessna 150L · Ocean Springs, MSThe loss of engine power for undetermined reasons.Feb 14, 1994 · N10797 · Substantial damage NTSB MIA90FA017Accident · 1 fatalField investigationFinal reportCessna 150L · Columbia, MSSuicide. The pilot's emotional state of distress was a related factor.Oct 25, 1989 · N19007 · Destroyed NTSB ATL86LA046Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Mendenhall, MSThe plt stated that the acft collided with a tree while he was making a low pass over his father's home. The plt said his attention was diverted while making a left turn and the acft descended into the tree.Dec 21, 1985 · N6712G · Substantial damage NTSB ATL85FLT12Accident · Serious injuriesFinal reportCessna 150L · Tunica, MSThe acft sustained substantial damage during a forced landing in a cotton fld following fuel exhaustion. Purpose of the flt was to take aerial photographs. Post accident inspection of the acft disclosed 2.5 gallons of fuel remaining in the right fuel tank and…Sep 20, 1985 · N10735 · Substantial damage NTSB ATL85LA232Accident · No injuriesLimited investigationFinal reportCessna 150L · Hattiesburg, MSDuring a full-flap approach to landing, the pilot saw that the acft was going to land long and he initiated a go-around. He began retracting the flaps at the same time, and the acft started to settle. The pilot then elected to continue the landing straight…Aug 3, 1985 · N7952G · Substantial damage NTSB ATL83LA110Accident · No injuriesLimited investigationFinal reportCessna 150 · Columbus, MSThe acft collided with a tree during a forced landing. The acft was descending returning from a fire patrol when the engine quit. The right fuel gauge was on empty and the left tank showed 1/4 of a tank. Attempts to restart the engine were unsuccessful and…Feb 19, 1983 · N1327Q · Substantial damage NTSB MIA79FA097Accident · 2 fatalClosedCessna 150L · Meridian, MSJun 16, 1979 · N19192 · Destroyed NTSB MIA78FKQ35Accident · Minor injuriesClosedCessna 150 · Biloxi, MSAug 26, 1978 · N1529Q · Substantial damage NTSB MIA78FKQ07Accident · Serious injuriesClosedCessna 150L · Hallandale, MSApr 14, 1978 · N1531Q · Destroyed NTSB MIA77FA090Accident · 1 fatalClosedCessna 150 · Water Valley, MSSep 24, 1977 · N6677G · Destroyed NTSB MIA76FKQ48Accident · No injuriesClosedCessna 150L · Meridian, MSAug 29, 1976 · N6647G · Substantial damage NTSB MIA76FKQ37Accident · No injuriesClosedCessna A188B · Hollandale, MSJul 9, 1976 · N6694G · Substantial damage NTSB MIA76AM060Accident · Minor injuriesClosedCessna 150L · Walls, MSFeb 8, 1976 · N11626 · 2 aircraft · Substantial damage NTSB MIA74FKQ18Accident · Serious injuriesClosedCessna 150L · Hattiesburg, MSApr 28, 1974 · N1777Q · Destroyed NTSB MIA73AM070Accident · 2 fatalClosedCessna 150 · Meridian, MSJan 5, 1973 · N6884G · Destroyed NTSB MIA73DLT03Accident · No injuriesClosedCessna 150 · Olive Branch, MSSep 5, 1972 · N1294Q · Substantial damage