NTSB investigations: Cessna 150M, IA
17 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.
Cases per year
| 1975 | 1 |
|---|---|
| 1977 | 3 |
| 1978 | 3 |
| 1982 | 1 |
| 1984 | 1 |
| 1986 | 1 |
| 1994 | 1 |
| 1996 | 1 |
| 1997 | 1 |
| 1999 | 1 |
| 2005 | 1 |
| 2008 | 2 |
Where
Open the mapLatest cases
Query with SQL
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\" = 'IA' 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" = 'IA' 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" DESCRun 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 CEN09CA121Accident · No injuriesData collectionFinal reportCessna 150M · Greene, IAA loss of engine power due to undetermined reasons. Contributing to the accident was the rough, snow-covered terrain.NTSB CEN09CA021Accident · Serious injuriesData collectionFinal reportCessna 150M · Iowa City, IAFuel exhaustion due to the pilot's failure to visually verify that sufficient fuel was on-board prior to flight.NTSB CHI06CA046Accident · Minor injuriesData collectionFinal reportCessna 150M · Algona, IAThe pilot's inadvertent flight into unexpected instrument conditions and his visual look out not possible during takeoff leading to the nose over during the emergency landing after takeoff. Factors were the unexpected fog and the dark night conditions.NTSB CHI99LA281Accident · No injuriesLimited investigationFinal reportCessna 150M · Perry, IAthe student pilot's inadequate compensation for the wind conditions which resulted in her failure to maintain control of the airplane. A factor associated with the accident was the gusty crosswind condition.NTSB CHI97FA067Accident · 1 fatalField investigationFinal reportCessna 150 · Larchwood, IAthe noninstrument-rated pilot's takeoff into instrument meteorological conditions. The weather was a factor.NTSB CHI96LA254Accident · No injuriesLimited investigationFinal reportCessna 150 · Dubuque, IAinadequate airspeed and the student pilot's failure to perform a recovery from the bounced landing. Factors associated with the accident were the crosswind and the student's over compensation for the crosswind.NTSB CHI94LA343Accident · No injuriesLimited investigationFinal reportCessna 150 · North Hedrick, IAInadequate preflight planning and the selection of unsuitable terrain on which to initiate a takeoff. A factor in this accident was the pilot's lack of overall experience.NTSB MKC86LA054Accident · No injuriesLimited investigationFinal reportCessna 150 · Bancroft, IAThe plt became disoriented on a night, VFR flt and landed at an arpt to determine his location. The unattended arpt did not have a phone so the plt tookoff again enroute to his original dest. He became disoriented a second time and, because the acft was…NTSB MKC84LA278Accident · No injuriesLimited investigationFinal reportCessna C-150M · Council Bluffs, IAStudent plt departed on supervised solo flt. Later, instructor noted wind conditions at the airport had become unfavorable & advised plt by radio to divert to a specific alternate where winds conditions were favorable. Plt disregarded advice, proceeded to…NTSB MKC82DA132Accident · No injuriesFinal reportCessna 150 · Davenport, IAUnauthorized persons stole money and aircraft keys and attempted a takeoff in a Cessna 150 from a taxiway. The aircraft collided with a runway light and stalled after flying a few hundred feet. The parties involved have not been identified. Injury index is…NTSB MKC79DCD01Accident · No injuriesClosedCessna 150 · Council Bluffs, IANTSB MKC78FCD51Accident · Serious injuriesClosedCessna 150 · New Albin, IANTSB MKC78DCD17Accident · No injuriesClosedCessna 150 · Cumberland, IANTSB MKC78DCD10Accident · Minor injuriesClosedCessna 150 · Tipton, IANTSB MKC78DCD07Accident · Minor injuriesClosedCessna 150 · Des Moines, IANTSB MKC77FCD19Accident · Serious injuriesClosedCessna 150M · Council Bluffs, IANTSB MKC76DCD11Accident · No injuriesClosedCessna 150 · Desmoines, IA