NTSB investigations: Cessna A150L, CA
22 cases on aircraft the registry lists as Cessna A150L. 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
| 1971 | 1 |
|---|---|
| 1972 | 2 |
| 1973 | 4 |
| 1974 | 6 |
| 1975 | 2 |
| 1977 | 1 |
| 1978 | 2 |
| 1979 | 2 |
| 1981 | 1 |
| 1991 | 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 ('2071828'))
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 ('2071828'))
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 LAX91FA242Accident · 1 fatalField investigationFinal reportCessna C-A150L · Cottonwood, CAThe pilot's intentional low pass during which he performed an aerobatic maneuver with inadequate airspeed. Contributing factors were the pilot's low altitude and the tailwind condition which created the visual perception to the pilot of having an airspeed…NTSB LAX81FA102Accident · Minor injuriesClosedCessna 150 · Irwindale, CANTSB LAX80FVM01Accident · No injuriesClosedCessna 150 · Hollister, CANTSB LAX79FA028Accident · 1 fatalClosedCessna A150L · Fillmore, CANTSB OAK78FVG47Accident · Minor injuriesClosedCessna 150 · Angels Camp, CANTSB LAX78FUQ18Accident · Serious injuriesClosedCessna A150J · Thousand Oaks, CANTSB OAK77FVG52Accident · Serious injuriesClosedCessna 150 · Folsom, CANTSB OAK76AP036Accident · 2 fatalClosedCessna 150L · Etna, CANTSB OAK75APO43Accident · 2 fatalClosedCessna A150L · Morgan Hill, CANTSB OAK75FVM15Accident · No injuriesClosedCessna 150 · Woodside, CANTSB LAX74FUA11Accident · No injuriesClosedCessna 150 · Laguna Bch, CANTSB OAK74DVA02Accident · No injuriesClosedCessna 150L · Firebaugh, CANTSB OAK75AP001Accident · 1 fatalClosedCessna A150L · Yuba City, CANTSB OAK74FVA78Accident · No injuriesClosedCessna A150L · Visalia, CANTSB OAK74DVA74Accident · No injuriesClosedCessna 150L · Groveland, CANTSB LAX74AL045Accident · 2 fatalClosedCessna A150L · Lucerne Vly, CANTSB LAX74FUA10Accident · No injuriesClosedCessna 150 · Santa Ana, CANTSB OAK74FVM06Accident · Minor injuriesClosedCessna 150 · San Jose, CANTSB LAX73AL061Accident · 1 fatalClosedCessna 150L · Playa D.Rey, CANTSB OAK73AP012Accident · 2 fatalClosedCessna A150L · Yorkville, CANTSB LAX72DUQ94Accident · No injuriesClosedCessna A150 · Pacoima, CANTSB LAX72DUG38Accident · No injuriesClosedCessna 150 · Chino, CA