Skip to content

NTSB investigations · 1,653

Matched to the registry by N-number and event date, 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_aircrafts.parquet' a JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c."mKey" = a.case_mkey WHERE a.aircraft_model_code IN ('2071814') 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_aircrafts.parquet' a JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c.\"mKey\" = a.case_mkey
  WHERE a.aircraft_model_code IN ('2071814')
  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_aircrafts.parquet' a JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c."mKey" = a.case_mkey
WHERE a.aircraft_model_code IN ('2071814')
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 MKC68A0014Accident · 2 fatalClosedCessna 150 · Jefferson City, MOAug 25, 1967 · N563Q · Destroyed NTSB FTW68F0176Accident · No injuriesClosedCessna 150 · New Orleans, LAAug 23, 1967 · N6650F · Substantial damage NTSB FTW68F0159Accident · No injuriesClosedCessna 150 · Houston, TXAug 23, 1967 · N6456F · Substantial damage NTSB FTW68D0173Accident · No injuriesClosedCessna 150 · Abilene, TXAug 21, 1967 · N8726G · Destroyed NTSB NYC68D0137Accident · No injuriesClosedCessna 150 · Bloomingburgh, NYAug 19, 1967 · N6449F · Substantial damage NTSB LAX68D0122Accident · No injuriesClosedCessna 150 · Snowflake, AZAug 19, 1967 · N6682F · Substantial damage NTSB OAK68D0127Accident · No injuriesClosedCessna 150F · Independnce, CAAug 18, 1967 · N7832F · Destroyed NTSB CHI68D0228Accident · No injuriesClosedCessna 150 · Greenwood, ILAug 16, 1967 · N6933F · Substantial damage NTSB MKC68D0152Accident · No injuriesClosedCessna 150 · Rapid City, SDAug 15, 1967 · N6725F · Substantial damage NTSB NYC68D0106Accident · No injuriesClosedCessna 150 · Sterling Jct, MAAug 12, 1967 · N3063X · Substantial damage NTSB FTW68F0165Accident · No injuriesClosedCessna 150F · Crane, TXAug 12, 1967 · N8035F · Substantial damage NTSB DEN68D0061Accident · No injuriesClosedCessna 150 · Cimarron, NMAug 12, 1967 · N7808F · Substantial damage NTSB SEA68D0135Accident · No injuriesClosedCessna 150 · Everett, WAAug 11, 1967 · N6511F · Substantial damage NTSB LAX68D0115Accident · No injuriesClosedCessna 150 · Agua Dulce, CAAug 10, 1967 · N7178F · Substantial damage NTSB FTW68F0152Accident · No injuriesClosedCessna 150 · Friendswood, TXAug 10, 1967 · N6872F · Substantial damage NTSB OAK68D0069Accident · No injuriesClosedCessna 150 · Sacramento, CAAug 9, 1967 · N6587F · Substantial damage NTSB DEN68D0058Accident · No injuriesClosedCessna 150 · Springer, NMAug 8, 1967 · N8228F · Substantial damage NTSB FTW68D0149Accident · No injuriesClosedCessna 150 · Pearland, TXAug 6, 1967 · N6722F · Substantial damage NTSB SEA68F0068Accident · No injuriesClosedCessna 150 · Moses Lake, WAAug 5, 1967 · N8652G · Substantial damage NTSB MKC68D0220Accident · Minor injuriesClosedCessna 150 · Neosho, MOAug 5, 1967 · N8740S · Destroyed NTSB FTW68F0129Accident · No injuriesClosedCessna 150 · Pearland, TXAug 5, 1967 · N8609S · Substantial damage NTSB OAK68D0141Accident · No injuriesClosedCessna 150 · Mountain City, NVAug 2, 1967 · N6406F · Substantial damage NTSB SEA68F0125Accident · No injuriesClosedCessna 150F · Beaverton, ORAug 1, 1967 · N8419G · Substantial damage NTSB LAX68F0085Accident · No injuriesClosedCessna 150F · Hawthorne, CAJul 31, 1967 · N8657S · Substantial damage NTSB CHI68F0112Accident · No injuriesClosedCessna 150 · Ann Arbor, MIJul 31, 1967 · N8299S · Substantial damage NTSB LAX68D0145Accident · No injuriesClosedCessna 150 · Palm Sprngs, CAJul 28, 1967 · N6440F · Substantial damage NTSB OAK68D0219Accident · No injuriesClosedCessng 150 · Reno, NVJul 27, 1967 · N6742F · Substantial damage NTSB NYC68F0097Accident · No injuriesClosedCessna 150F · Marilla, NYJul 26, 1967 · N8176F · Substantial damage NTSB FTW68F0098Accident · No injuriesClosedCessna 150F · Wynnewood, OKJul 25, 1967 · N8284S · Substantial damage NTSB LAX68A0011Accident · 2 fatalClosedCessna 150F · Kingman, AZJul 24, 1967 · N8243S · Destroyed NTSB MIA68F0183Accident · Serious injuriesClosedCessna 150 · Douglasville, GAJul 23, 1967 · N7007F · Substantial damage NTSB MIA68D0089Accident · No injuriesClosedCessna 150 · Miami, FLJul 23, 1967 · N8531G · Substantial damage NTSB MKC68F0318Accident · No injuriesClosedCessna 150 · Ft Leonrd Wood, MOJul 22, 1967 · N8835S · Substantial damage NTSB MKC68D0131Accident · No injuriesClosedCessna 150 · St.Charles, MOJul 22, 1967 · N8666S · Substantial damage NTSB MIA68F0082Accident · No injuriesClosedCessna 150 · Hialeah, FLJul 22, 1967 · N7700F · Substantial damage NTSB DEN68D0035Accident · No injuriesClosedCessna 150 · Broomfield, COJul 22, 1967 · N6640F · Substantial damage NTSB MIA68D006UAccident · No injuriesClosedCessna 150 · Lawrenceburg, TNJul 21, 1967 · N8969S · Substantial damage NTSB DIA68D0038Accident · Minor injuriesClosedCessna 150 · Little River, SCJul 21, 1967 · N8479G · Destroyed NTSB LAX68F0057Accident · No injuriesClosedCessna 150 · Riverside, CAJul 18, 1967 · N6871F · Substantial damage NTSB SEA68D0118Accident · No injuriesClosedCessna 150F · Sutherlin, ORJul 16, 1967 · N6533F · Substantial damage NTSB CHI68F0076Accident · Minor injuriesClosedCessna 150 · Hillsdale, MIJul 13, 1967 · N7920F · Destroyed NTSB MKC68D0079Accident · No injuriesClosedCessna 150 · Cedar Rapids, IAJul 12, 1967 · N8802S · Substantial damage NTSB NYC68D0060Accident · No injuriesClosedCessna 150 · Shirley, MAJul 11, 1967 · N3099X · Destroyed NTSB MKC68D0117Accident · No injuriesClosedCessna 150 · Republic, MOJul 10, 1967 · N3060X · Substantial damage NTSB FTW68D0030Accident · No injuriesClosedCessna 150 · New Orleans, LAJul 8, 1967 · N6691F · Substantial damage NTSB FTW68F0046Accident · No injuriesClosedCessna 150F · Pearland, TXJul 7, 1967 · N6456F · 2 aircraft · Substantial damage NTSB FTW68F0046Accident · No injuriesClosedCessna 150F · Pearland, TXJul 7, 1967 · N8173S · 2 aircraft · Substantial damage NTSB FTW68D0029Accident · No injuriesClosedCessna 150 · Fort Worth, TXJul 6, 1967 · N8595G · Substantial damage NTSB DEN68F0012Accident · Serious injuriesClosedCessna 150 · Watkins, COJul 5, 1967 · N7140F · Substantial damage NTSB SEA68D0022Accident · No injuriesClosedCessna 150 · Inchelium, WAJul 4, 1967 · N8184F · Substantial damage

Back to Cessna 150F