NTSB investigations: Cessna 150H, CT
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.
Cases per year
| 1969 | 1 |
|---|---|
| 1970 | 1 |
| 1971 | 1 |
| 1975 | 1 |
| 1982 | 1 |
| 1984 | 1 |
| 1989 | 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 ('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" = '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 ('2071818'))
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 NYC90LA008Accident · No injuriesLimited investigationFinal reportCessna 150 · Madison, CTA loss of engine power, due to a stuck exhaust valve in the number 4 cylinder. Factors related to the accident were: the pilot's excessive airspeed on final approach, and his failure to attain the proper touchdown point during the landing.NTSB NYC84FNE04Accident · Serious injuriesFinal reportCessna 150H · Burlington, CTThe plt reported he 'picked up the acft after annual inspection', performed a preflt, made a standard run-up & took off in calm air conditions. After clmbing about 500 to 600 ft, the eng lost power & subsequently, the acft crash landed in a marsh. The plt was…NTSB NYC82DA163Accident · No injuriesFinal reportCessna 150H · Ansonia, CTThe pilot flew to another local airport to practice touch and go landings. During the takeoff from the 1750 foot runway the aircraft stalled into the trees. The pilot stated that the aircraft settled into the tree tops when he maneuvered to avoid power lines.NTSB NYC76AN002Accident · No injuriesClosedCessna 150 · Marlborough, CTNTSB NYC71IN076Incident · No injuriesClosedCessna 150 · Danbury, CTNTSB NYC70FFM10Accident · Minor injuriesClosedCessna 150H · Windham, CTNTSB NYC70A0064Accident · 1 fatalClosedCessna 150H · Woodbury, CT