Skip to content

NTSB investigations: Cessna A150L

84 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases, newest first

Query with SQL

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."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

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.\"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."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

Run 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 MIA76DKT73Accident · Minor injuriesClosedCessna 150A · Ft Lauderdale, FLApr 29, 1976 · N9963G · Substantial damage NTSB MIA76FLG25Accident · Minor injuriesClosedCessna A150L · Bath, SCJan 24, 1976 · N6032J · Substantial damage NTSB OAK76AP036Accident · 2 fatalClosedCessna 150L · Etna, CADec 29, 1975 · N6028J · Destroyed NTSB NYC76FNA09Accident · No injuriesClosedCessna 150 · Norwood, MAAug 9, 1975 · N7949F · Substantial damage NTSB NYC75DNC38Accident · No injuriesClosedCessna A150 · Shelbourne, VTJun 21, 1975 · N6154F · Destroyed NTSB MKC75DCJ51Accident · No injuriesClosedCessna 150 · Kearney, NEMay 4, 1975 · N9982G · Substantial damage NTSB SEA75DYI21Accident · No injuriesClosedCessna 150 · Bend, ORApr 9, 1975 · N9934G · Substantial damage NTSB NYC75FNE32Accident · No injuriesClosedCessna A150L · Simsbury, CTApr 5, 1975 · N6503F · Substantial damage NTSB OAK75APO43Accident · 2 fatalClosedCessna A150L · Morgan Hill, CAMar 16, 1975 · N6074J · Destroyed NTSB MIA75AM056Accident · 1 fatalClosedCessna A150L · Ocala, FLFeb 11, 1975 · N6153F · Destroyed NTSB OAK75FVM15Accident · No injuriesClosedCessna 150 · Woodside, CADec 7, 1974 · N6048J · Substantial damage NTSB LAX74FUA11Accident · No injuriesClosedCessna 150 · Laguna Bch, CAOct 25, 1974 · N9911G · Substantial damage NTSB LAX75FUJ21Accident · No injuriesClosedCessna A150L · Marana, AZAug 17, 1974 · N5992J · Substantial damage NTSB MIA74DKJ09Accident · No injuriesClosedCessna A150L · Meridianville, ALAug 8, 1974 · N6073J · Substantial damage NTSB OAK74DVA02Accident · No injuriesClosedCessna 150L · Firebaugh, CAJul 5, 1974 · N8080L · Substantial damage NTSB OAK75AP001Accident · 1 fatalClosedCessna A150L · Yuba City, CAJul 2, 1974 · N6149F · Destroyed NTSB OAK74FVA78Accident · No injuriesClosedCessna A150L · Visalia, CAJun 23, 1974 · N5999J · Substantial damage NTSB OAK74DVA74Accident · No injuriesClosedCessna 150L · Groveland, CAJun 9, 1974 · N8080L · Substantial damage NTSB DEN74AD053Accident · 2 fatalClosedCessna A150L · Rio Rancho, NMApr 23, 1974 · N6062J · Destroyed NTSB FTW74AF075Accident · 2 fatalClosedCessna A150 · Haslet, TXApr 20, 1974 · N6022J · Destroyed NTSB FTW74FRA25Accident · No injuriesClosedCessna 150L · Wharton, TXFeb 4, 1974 · N6023J · Substantial damage NTSB MIA74AM063Accident · 1 fatalClosedCessna A150L · Melbourne, FLJan 28, 1974 · N5930J · Destroyed NTSB LAX74AL045Accident · 2 fatalClosedCessna A150L · Lucerne Vly, CADec 20, 1973 · N6043J · Destroyed NTSB IAD74AI022Accident · 2 fatalClosedCessna 150L · Gatlinburg, TNNov 2, 1973 · N99PR · Destroyed NTSB LAX74FUA10Accident · No injuriesClosedCessna 150 · Santa Ana, CAOct 29, 1973 · N5963J · Substantial damage NTSB CHI74AC026Accident · 2 fatalClosedCessna A150L · Holly, MISep 23, 1973 · N6047J · Destroyed NTSB OAK74FVM06Accident · Minor injuriesClosedCessna 150 · San Jose, CAAug 10, 1973 · N5988J · Substantial damage NTSB MKC74DTG04Accident · No injuriesClosedCessna 150 · Mayville, NDAug 10, 1973 · N5956J · Substantial damage NTSB LAX73AL061Accident · 1 fatalClosedCessna 150L · Playa D.Rey, CAJun 7, 1973 · N5927J · Destroyed NTSB OAK73AP012Accident · 2 fatalClosedCessna A150L · Yorkville, CANov 25, 1972 · N5949J · Destroyed NTSB LAX72DUQ94Accident · No injuriesClosedCessna A150 · Pacoima, CAMay 23, 1972 · N5969J · Substantial damage NTSB LAX72DUG38Accident · No injuriesClosedCessna 150 · Chino, CADec 5, 1971 · N5927J · Substantial damage NTSB MIA71AM111Accident · 2 fatalClosedCessna A150L · Tallahassee, FLJun 8, 1971 · N5940J · Destroyed NTSB MIA71AM073Accident · 2 fatalClosedCessna A150L · Chatom, ALFeb 20, 1971 · N5951J · Destroyed