Skip to content

NTSB investigations: Cessna 150A

132 cases on aircraft the registry lists as Cessna 150A. 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 ('2071804')) 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 ('2071804'))
  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 ('2071804'))
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 MIA66D0284Accident · No injuriesClosedCessna 150 · Miami, FLNov 1, 1965 · N6697T · Substantial damage NTSB NYC66F0317Accident · No injuriesClosedCessna 150 · Paramus, NJOct 31, 1965 · N6677T · Substantial damage NTSB CHI66D0495Accident · No injuriesClosedCessna 150E · Louisville, OHOct 8, 1965 · N7214X · Substantial damage NTSB LAX66D0119Accident · No injuriesClosedCessna 150 · Wasco, CASep 29, 1965 · N7102X · Substantial damage NTSB OAK66D0086Accident · No injuriesClosedCessna 150 · Honolulu, HISep 26, 1965 · N6674T · Substantial damage NTSB FTW66D0252Accident · No injuriesClosedCessna 150 · Clarendon, TXAug 28, 1965 · N7103X · Substantial damage NTSB ANC66D0054Accident · No injuriesClosedCessna 150 · Glenallen, AKAug 7, 1965 · N7168X · Substantial damage NTSB FTW66D0287Accident · No injuriesClosedCessna 150 · Edinburg, TXAug 5, 1965 · N6669T · Substantial damage NTSB MIA66F0080Accident · Minor injuriesClosedCessna 150 · Tiptonville, TNJul 5, 1965 · N7094X · Substantial damage NTSB ANC66D0004Accident · No injuriesClosedCessna 150 · Northway, AKJun 9, 1965 · N7101X · Substantial damage NTSB ANC65D0016Accident · No injuriesClosedCessna 150 · Nenana, AKJun 5, 1965 · N7116X · Substantial damage NTSB CHI65D0158Accident · Minor injuriesClosedCessna 182 · Fostoria, OHMay 8, 1965 · N3835D · Substantial damage NTSB MKC65D0072Accident · No injuriesClosedCessna 150A · Audubon, IAApr 6, 1965 · N6654T · Substantial damage NTSB CHI65F0010Accident · No injuriesClosedCessna 150 · Wadsworth, OHJan 28, 1965 · N7061X · Substantial damage NTSB LAX65D0026Accident · No injuriesClosedCessna 170B · Hawthorne, CAJan 16, 1965 · N2819C · 2 aircraft · Minor damage NTSB UNK65X0868Accident · 1 fatalClosedCessna 150 · Georgetown, TXNov 28, 1964 · N7123X · Destroyed NTSB UNK65X0809Accident · 3 fatalClosedCessna 150D · Pomona, CANov 23, 1964 · N4359U · 2 aircraft · Destroyed NTSB UNK65X0128Accident · No injuriesClosedCessna 150 · Alliance, OHOct 3, 1964 · N7098X · Substantial damage NTSB UNK64X4136Accident · No injuriesClosedCessna 150 · Longmont, COSep 25, 1964 · N7231X · Substantial damage NTSB UNK64X3512Accident · No injuriesClosedCessna 150 · Mountain Home, IDAug 21, 1964 · N6653T · Substantial damage NTSB UNK64X3403Accident · 2 fatalClosedCessna 150A · Clarksdale, MSAug 15, 1964 · N7022X · Destroyed NTSB UNK64X2710Accident · No injuriesClosedCessna 150 · Rhinebeck, NYJul 8, 1964 · N6680T · Substantial damage NTSB UNK64X2699Accident · No injuriesClosedCessna 150 · El Monte, CAJul 7, 1964 · N7091X · Substantial damage NTSB UNK64X2400Accident · No injuriesClosedCessna 150 · Denver, COJun 20, 1964 · N7064X · Substantial damage NTSB UNK64X2318Accident · No injuriesClosedCessna 150 · Butler, GAJun 16, 1964 · N7204X · Substantial damage NTSB UNK64X1602Accident · No injuriesClosedCessna 150 · St Meinrad, INMay 3, 1964 · N7115X · Substantial damage NTSB UNK64X1566Accident · No injuriesClosedCessna 150A · Boca Raton, FLMay 2, 1964 · N6638T · Substantial damage NTSB UNK64X1040Accident · No injuriesClosedCessna 150 · Wray, COMar 26, 1964 · N6688T · Destroyed NTSB UNK64X0588Accident · No injuriesClosedCessna 150 · Broomfield, COFeb 16, 1964 · N7025X · Substantial damage NTSB UNK64X0431Accident · No injuriesClosedCessna 150 · Ames, IAFeb 2, 1964 · N6692T · Substantial damage NTSB UNK64X0207Accident · No injuriesClosedCessna 150A · Italy, TXJan 10, 1964 · N6632T · Substantial damage NTSB UNK64X0175Accident · No injuriesClosedCessna 150A · Atlanta, GAJan 6, 1964 · N7088X · Destroyed