NTSB investigations: Cessna 150C, CA
18 cases on aircraft the registry lists as Cessna 150C. 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 | 5 |
|---|---|
| 1965 | 1 |
| 1966 | 2 |
| 1968 | 2 |
| 1970 | 1 |
| 1973 | 1 |
| 1975 | 1 |
| 1977 | 1 |
| 1979 | 1 |
| 1981 | 1 |
| 1983 | 1 |
| 2021 | 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\" = 'CA' 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 ('2071808'))
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" = 'CA' 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 ('2071808'))
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 WPR22LA071Accident · No injuriesClass 4 · LimitedFinal reportCessna 150C · Johnsondale, CAThe pilot’s failure to maintain directional control of the airplane while landing on a snow-covered unimproved runway.NTSB LAX83LA206Accident · Minor injuriesLimited investigationFinal reportCessna 150C · Madera, CAThe plt was flying in & out of several crop duster strips. During takeoff from the 4th strip the engine quit. The acft nosed over in a plowed field. The plt attributed the engine failure to water in fuel.NTSB LAX81FVD12Accident · No injuriesClosedCessna 150 · Tracy, CANTSB OAK79DVG42Accident · No injuriesClosedCessna 172 · Placerville, CANTSB LAX78FVA18Accident · Serious injuriesClosedCessna 150C · Bakersfield, CANTSB LAX76FUM08Accident · No injuriesClosedCessna 150 · Ramona, CANTSB OAK74AP024Accident · 3 fatalClosedCessna 150C · Stockton, CANTSB OAK70FVG34Accident · Serious injuriesClosedCessna 150C · Napa, CANTSB OAK69D0114Accident · Minor injuriesClosedCessna 150 · Lake Tahoe, CANTSB LAX69D0024Accident · No injuriesClosedCessna 150 · Hemet, CANTSB OAK67D0110Accident · No injuriesClosedCessna 150 · San Carlos, CANTSB LAX67D0109Accident · Minor injuriesClosedCessna 150 · Banning, CANTSB OAK66D0105Accident · No injuriesClosedCessna 150 · San Jose, CANTSB UNK65X0830Accident · Minor injuriesClosedCessna 150C · Santa Monica, CANTSB UNK65X0252Accident · 2 fatalClosedCessna 150C · Chino, CANTSB UNK64X1846Accident · No injuriesClosedCessna 150 · Walnut Grove, CANTSB UNK64X1592Accident · Minor injuriesClosedCessna 150 · Santa Rosa, CANTSB UNK64X0230Accident · No injuriesClosedCessna 150 · Ridgecrest, CA