Skip to content

NTSB investigations · 489

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 ('2071802') 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 ('2071802')
  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 ('2071802')
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 SEA75DYA36Accident · No injuriesClosedCessna 150 · Boise, IDApr 19, 1975 · N7815E · Substantial damage NTSB MIA75FLD64Accident · No injuriesClosedCessna 150 · Plant City, FLApr 7, 1975 · N5523E · Substantial damage NTSB MKC75DCQ33Accident · No injuriesClosedCessna 150 · Concordia, KSFeb 19, 1975 · N1366Q · Substantial damage NTSB IAD75FKW09Accident · Serious injuriesClosedCessna 150 · Monterey, TNJan 1, 1975 · N6555T · Substantial damage NTSB CHI75AC044Accident · 1 fatalClosedCessna 150J · Utica, MIDec 9, 1974 · N51370 · Destroyed NTSB MKC75AK029Accident · 1 fatalClosedCessna 150 · Johnston, IADec 5, 1974 · N5797G · Destroyed NTSB MKC75DCG19Accident · No injuriesClosedCessna 150 · Corder, MONov 15, 1974 · N10486 · Substantial damage NTSB OAK75FVW07Accident · Minor injuriesClosedCessna 150K · Las Vegas, NVOct 18, 1974 · N6279G · Substantial damage NTSB NYC75DFJ14Accident · No injuriesClosedCessna 150 · Kirkwood, NYOct 11, 1974 · N17084 · Substantial damage NTSB CHI75AC030Accident · 2 fatalClosedCessna 150L · Morris, ILOct 8, 1974 · N19048 · Destroyed NTSB NYC75FHA17Accident · No injuriesClosedCessna 150 · Slatington, PAOct 6, 1974 · N6594T · Substantial damage NTSB MIA75FKG13Accident · Serious injuriesClosedCessna 150 · Stockbridge, GAAug 1, 1974 · N1751Q · Substantial damage NTSB MIA75DKT04Accident · Serious injuriesClosedCessna 150J · Riviera Beach, FLJul 15, 1974 · N51056 · Substantial damage NTSB OAK74DXQ40Accident · No injuriesClosedCessna 150 · Lake Tahoe, CAMay 22, 1974 · N5923G · Substantial damage NTSB NYC74FHM27Accident · Serious injuriesClosedCessna 150G · Hanover, NJMay 8, 1974 · N3231J · Destroyed NTSB NYC74FNE21Accident · Serious injuriesClosedCessna 150L · Ashford, CTApr 26, 1974 · N5358Q · Destroyed NTSB SEA74FYC45Accident · No injuriesClosedCessna 150 · Grand Ronde, ORApr 12, 1974 · N5809E · Substantial damage NTSB OAK74FVG37Accident · No injuriesClosedCessna 150 · Foresthill, CAApr 7, 1974 · N6526T · Substantial damage NTSB MIA74DLT04Accident · Minor injuriesClosedCessna 150 · Corinth, MSFeb 9, 1974 · N5260Q · Substantial damage NTSB MIA74FLD62Accident · Minor injuriesClosedCessna 150 · Lake Wales, FLJan 31, 1974 · N7178X · Destroyed NTSB SEA74DYG21Accident · No injuriesClosedCessna 150 · Priest River, IDDec 2, 1973 · N7711E · Substantial damage NTSB MIA74DKT39Accident · No injuriesClosedCessna 150 · Clewiston, FLNov 20, 1973 · N5646E · Substantial damage NTSB MKC74AK021Accident · 2 fatalClosedCessna 150 · Conesville, IANov 11, 1973 · N7751E · Destroyed NTSB CHI74FET11Accident · Serious injuriesClosedCessna 150 · Michigan City, INNov 2, 1973 · N6987G · Substantial damage NTSB IAD74FKW18Accident · Serious injuriesClosedCessna 150H · Cleveland, TNOct 12, 1973 · N6533S · Destroyed NTSB LAX74FUG15Accident · No injuriesClosedCessna 150C · Adelanto, CASep 24, 1973 · N2029Z · Substantial damage NTSB CHI74FEK05Accident · No injuriesClosedCessna 150 · Newark, OHSep 19, 1973 · N18086 · Substantial damage NTSB FTW74FRG19Accident · No injuriesClosedCessna 150 · Portland, TXAug 31, 1973 · N5863E · Substantial damage NTSB NYC74DNC18Accident · No injuriesClosedCessna 150 · Burlington, VTAug 14, 1973 · N3551L · Substantial damage NTSB FTW74FPD05Accident · No injuriesClosedCessna 150 · Grand Prairie, TXAug 11, 1973 · N5628E · Substantial damage NTSB FTW73AF074Accident · 2 fatalClosedCessna 150C · Waco, TXJun 24, 1973 · N6906G · Destroyed NTSB MIA73AM113Accident · 2 fatalClosedCessna 150 · Tallahassee, FLJun 21, 1973 · N7908E · Destroyed NTSB MKC73DCG50Accident · No injuriesClosedCessna 150 · Marshall, MOJun 20, 1973 · N3030J · Destroyed NTSB DEN74DTE11Accident · No injuriesClosedCessna 150 · Sterling, COJun 18, 1973 · N7735F · Substantial damage NTSB NYC73FNA51Accident · Minor injuriesClosedCessna 150 · Tiverton, RIJun 3, 1973 · N6517T · Substantial damage NTSB OAK73DVM33Accident · Minor injuriesClosedCessna 150 · Pescadero, CAMay 29, 1973 · N7028X · Destroyed NTSB IAD73FKW25Accident · Minor injuriesClosedCessna 150 · Stroudsville, TNMay 14, 1973 · N18672 · Substantial damage NTSB OAK73FVM30Accident · Serious injuriesClosedCessna 150 · Pacifica, CAApr 24, 1973 · N22446 · Destroyed NTSB NYC73AN133Accident · 1 fatalClosedCessna 150 · Princeton, MAApr 16, 1973 · N19057 · Destroyed NTSB MKC73FCG35Accident · Minor injuriesClosedCessna 150G · Leawood, KSMar 25, 1973 · N3157J · Substantial damage NTSB LAX73AL045Accident · 2 fatalClosedCessna 150J · Newhall, CAMar 21, 1973 · N51362 · Destroyed NTSB NYC73DLJ20Incident · No injuriesClosedCessna 150 · Askewville, NCFeb 25, 1973 · N5755E · Minor damage NTSB SEA73AS022Accident · 1 fatalClosedCessna 150L · Estacada, ORFeb 11, 1973 · N5333Q · Destroyed NTSB FTW73FPD18Accident · Serious injuriesClosedCessna 150 · Denton, TXJan 13, 1973 · N5518E · Substantial damage NTSB LAX73DVA34Accident · No injuriesClosedCessna 150 · Taft, CADec 17, 1972 · N7729E · Substantial damage NTSB NYC73FHJ10Accident · No injuriesClosedCessna 150L · N.Bayshore, NYDec 3, 1972 · N5358Q · Substantial damage NTSB DEN73DQA21Accident · No injuriesClosedCessna 150 · Aztec, NMNov 18, 1972 · N5703E · Substantial damage NTSB MKC73AK036Accident · 1 fatalClosedCessna 150F · Long Pine, NENov 5, 1972 · N7704F · Destroyed NTSB NYC73DNC35Accident · Minor injuriesClosedCessna 150 · Rockland, MEOct 26, 1972 · N5664E · Destroyed NTSB MIA73AM042Accident · 2 fatalClosedCessna 150L · Eads, TNOct 16, 1972 · N18142 · Destroyed

Back to Cessna 150