Fatal NTSB investigations: Cessna 150B
15 cases on aircraft the registry lists as Cessna 150B. 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
| 1964 | 1 |
|---|---|
| 1965 | 1 |
| 1966 | 1 |
| 1967 | 1 |
| 1968 | 1 |
| 1969 | 1 |
| 1970 | 1 |
| 1971 | 2 |
| 1978 | 1 |
| 1980 | 1 |
| 1985 | 1 |
| 1986 | 1 |
| 1996 | 1 |
| 2007 | 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.\"highestInjuryLevel\" = 'Fatal'
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2071806'))
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."highestInjuryLevel" = 'Fatal'
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2071806'))
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 NYC07FA176Accident · 2 fatalField investigationFinal reportCessna 150B · Campbellton, FLThe pilot's failure to maintain airspeed during the initial climb after takeoff, which resulted in an inadvertent stall.NTSB SEA96FA134Accident · 2 fatalField investigationFinal reportCessna 150B · Hailey, IDthe pilot's improper planning/decision, and his failure to maintain adequate airspeed during a climb over rising terrain, which resulted in a stall and collision with terrain. Factors relating to the accident were: failure of the pilot to ensure the airplane…NTSB LAX86FA183Accident · 1 fatalField investigationFinal reportCessna 150B · Bermuda Dunes, CAThe purpose of the research & development flight was to document through the use of videotape the deployment & trajectory of a speciality parachute which was connected to a ballast bag. The plt, who was the designer of the device, utilized his experimental…NTSB LAX86FA066Accident · 1 fatalField investigationFinal reportCessna 150 · Oxnard, CAThe acft took off, pitched up steeply, stalled, nosed over to the right and crashed, nose down into the grass south of the rwy. Post accident inspection of the acft disclosed that the 2 inch bolt the plt used as a control gust lock for the elevator and…NTSB ATL80FA083Accident · 1 fatalClosedCessna 150 · Henderson, KYNTSB LAX78FUG46Accident · 1 fatalClosedCessna 150B · Rialto, CANTSB NYC72AN083Accident · 1 fatalClosedCessna 150B · Allentown, PANTSB MKC72AK016Accident · 1 fatalClosedCessna 150B · Victoria, KSNTSB NYC70AN110Accident · 1 fatalClosedCessna 150B · Cranston, RINTSB MIA69A0085Accident · 2 fatalClosedCessna 150B · Ft.Meyers Bch, FLNTSB LAX69A0031Accident · 5 fatalClosedCessna 150B · Santa Paula, CANTSB FTW67A0109Accident · 1 fatalClosedCessna 150B · Lubbock, TXNTSB MKC66A0045Accident · 2 fatalClosedCessna 150B · Emporia, KSNTSB LAX65A0073Accident · 1 fatalClosedCessna 150B · Santa Maria, CANTSB UNK64X3385Accident · 2 fatalClosedCessna 150 · Monterey, CA