NTSB investigations: Cessna 150, FL
18 cases on aircraft the registry lists as Cessna 150. 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
| 1965 | 2 |
|---|---|
| 1966 | 1 |
| 1967 | 2 |
| 1968 | 3 |
| 1973 | 2 |
| 1974 | 2 |
| 1975 | 2 |
| 1977 | 1 |
| 1982 | 1 |
| 1991 | 1 |
| 2016 | 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\" = 'FL' 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 ('2071802'))
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" = 'FL' 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 ('2071802'))
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 ERA17LA071Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Palm Bay, FLUnknown maintenance personnel’s improper routing of electrical wires in the engine compartment, which resulted in chafing and a subsequent in-flight fire.NTSB MIA92LA022Accident · No injuriesLimited investigationFinal reportCessna 150 · Coleman, FLFailure of the unqualified pilot to maintain the proper glidepath while on final approach. Also, failure to perform the correct remedial action resulting in the collision with a power line.NTSB MIA82DA159Accident · No injuriesFinal reportCessna 150 · Englewood, FLAs the pilot was climbing through about 700 ft MSL, he observed a person on the beach waving at his aircraft. He thought the person was someone he knew so had made a descending turn to 500 ft to take a better look. When he determined that it was the wrong…NTSB MIA77FA079Accident · 1 fatalClosedCessna 150 · Ft.Lauderdale, FLNTSB MIA76AM033Accident · 1 fatalClosedCessna 150M · Hawthorne, FLNTSB MIA75FLD64Accident · No injuriesClosedCessna 150 · Plant City, FLNTSB MIA75DKT04Accident · Serious injuriesClosedCessna 150J · Riviera Beach, FLNTSB MIA74FLD62Accident · Minor injuriesClosedCessna 150 · Lake Wales, FLNTSB MIA74DKT39Accident · No injuriesClosedCessna 150 · Clewiston, FLNTSB MIA73AM113Accident · 2 fatalClosedCessna 150 · Tallahassee, FLNTSB MIA69F0294Accident · Minor injuriesClosedCessna 150F · Titusville, FLNTSB MIA69F0143Accident · No injuriesClosedCessna 150 · St.Augustine, FLNTSB MIA69D0022Accident · Minor injuriesClosedCessna 150 · Brooksville, FLNTSB MIA68F0260Accident · No injuriesClosedCessna 150 · Dinsmore, FLNTSB MIA67A0073Accident · 2 fatalClosedCessna 150 · Jacksonville, FLNTSB MIA66D0418Accident · Minor injuriesClosedCessna 150 · Homestead, FLNTSB MIA65F0058Accident · No injuriesClosedCessna 150 · Crystal Sprgs, FLNTSB MIA65D0059Accident · No injuriesClosedCessna 150 · Miami, FL