NTSB investigations: Cessna 150M, AL

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

19752026

NTSB investigations: Cessna 150M, AL per year, 1975–2026: 14 cases
1975	1
1976	1
1977	2
1978	1
1979	1
1981	1
1983	3
1985	1
1987	1
2005	1
2012	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" = 'AL' 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 ('2071830')) 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\" = 'AL' 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 ('2071830'))
  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" = 'AL' 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 ('2071830'))
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 ERA12CA396Accident · No injuriesData collectionFinal reportCessna 150M · Gulf Shores, ALThe student pilot's improper flight control inputs and the flight instructor's delayed remedial action during the attempted go-around, which resulted in an aerodynamic stall.Jun 14, 2012 · N9119U · Substantial damage NTSB ATL06CA012Accident · No injuriesData collectionFinal reportCessna 150 · Monroesville, ALThe pilot's failure to maintain directional control, which resulted in a loss of control and collision with trees.Nov 5, 2005 · N704VR · Substantial damage NTSB ATL87LA068Accident · 1 fatalLimited investigationFinal reportCessna 150M · Pinson, ALDuring intial climb after takeoff the eng quit and restarted more than once. The acft was turned back toward the departure rwy. During the turn, the wing struck a tree, control was lost, and the acft collided with the ground. Examination of the eng revealed…Jan 31, 1987 · N704FT · Substantial damage NTSB ATL85LA159Accident · No injuriesLimited investigationFinal reportCessna 150M · Andalusia, ALThe student plt reported that during a landing roll, the acft veered to the right, went off the right side of the rwy & collide with a dirt bank.May 11, 1985 · N3682V · Substantial damage NTSB ATL84IA029Incident · No injuriesIncident investigationFinal reportCessna 150M · Mobile, ALThe acft collided with a light pole while taxiing. The instructor pilot was preoccupied with locating a tie down spot.Oct 23, 1983 · N9196U · Minor damage NTSB ATL83LA274Accident · No injuriesLimited investigationFinal reportCessna 150M · Muscle Shoals, ALThe acft made a hard landing and nosed over during an attempted go-around. The acft according to the pilot was operatingat nearly max gross weight and the density alt was 2300 ft. he tried a go-around with full flaps extended. A turn was made to avoid…Jul 12, 1983 · N66185 · Substantial damage NTSB ATL83LA250Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Tuscaloosa, ALThe acft collided with a power line spanning a river during a low pass over the water. The pilot said the purpose of thelow pass was to look for his father in a boat. He said he thought he saw the boat and in pulling up the acft hit the power line. Control…Jul 2, 1983 · N8876U · Substantial damage NTSB ATL81DKJ30Accident · No injuriesClosedCessna 150M · Hamilton, ALAug 13, 1981 · N8127U · Destroyed NTSB MIA79DKJ37Accident · No injuriesClosedCessna 150 · Jacksonville, ALMay 1, 1979 · N6045K · Substantial damage NTSB MIA78DKJ20Accident · No injuriesClosedCessna 150 · Jacksonville, ALJan 31, 1978 · N714LQ · Substantial damage NTSB MIA77DKJ40Accident · No injuriesClosedCessna 150 · Tuscaloosa, ALMay 29, 1977 · N9234U · Substantial damage NTSB MIA77FKJ38Accident · No injuriesClosedCessna 150 · Ashland, ALMay 18, 1977 · N45197 · Substantial damage NTSB MIA77FKJ03Accident · Serious injuriesClosedCessna 150 · New Brockton, ALOct 25, 1976 · N802AA · Substantial damage NTSB MIA75FKJ65Accident · Serious injuriesClosedCessna 150 · Meridianville, ALJun 28, 1975 · N45378 · Substantial damage