NTSB investigations: Cessna 150M, CT
7 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 |
|---|---|
| 1979 | 1 |
| 1980 | 1 |
| 1982 | 1 |
| 1984 | 1 |
| 1986 | 1 |
| 1988 | 1 |
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\" = 'CT' 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" = 'CT' 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 NYC89LA050Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Lyme, CTImproper planning; the student pilot became lost and ran out of fuel. During the landing he misjudged distance, altitude and airspeed and overran the field colliding with trees.NTSB NYC86LA115Accident · No injuriesLimited investigationFinal reportCessna 150 · Woodstock, CTThe student pilot in a Cessna 150 was making a touch and go. He raised the flaps and then added power. He looked over to see if the flaps were retracting and when he looked straight ahead the left wheel was off the runway in soft terrain. He reduced power and…NTSB NYC84FA293Accident · No injuriesField investigationFinal reportCessna 150M · Meriden, CTA cesnna N45288 was above and slightly to the rear of Cessna N4669V when they collided on final approach over the displaced threshold to runway 36 at mmk. Both aircraft landed without further incident. There were no injuries.NTSB NYC82DA068Accident · No injuriesFinal reportCessna 150M · Washington, CTWhile practicing power on stalls and gliding turns the pilot stated that the engine would not respond with half throttle. A forced landing was made after passing up two rough fields for a more distant one at a higher altitude. The pilot stated he should have…NTSB NYC80FNE09Accident · No injuriesClosedCessna 150 · Windsor Locks, CTNTSB NYC79FA070Accident · No injuriesClosedCessna 172L · Simsbury, CTNTSB NYC76AN002Accident · No injuriesClosedCessna 150 · Marlborough, CT