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 MKC67F0424Accident · Serious injuriesClosedCessna 150F · Ft.Riley, KSDec 8, 1966 · N7862F · Substantial damage NTSB SEA67A0041Accident · 1 fatalClosedCessna 150F · Ndavenport, WADec 6, 1966 · N8888S · Destroyed NTSB DEN67D0179Accident · No injuriesClosedCessna 150 · Montrose, CODec 5, 1966 · N8804S · Substantial damage NTSB MKC67D0342Accident · No injuriesClosedCessna 150 · Olathe, KSDec 3, 1966 · N8080F · Substantial damage NTSB MIA67D0338Accident · No injuriesClosedCessna 150F · Decatur, ALNov 30, 1966 · N7797F · Substantial damage NTSB LAX67A0054Accident · 1 fatalClosedCessna 150 · Santee, CANov 30, 1966 · N6955F · Destroyed NTSB MKC67F0355Accident · No injuriesClosedCessna 150F · Hopkins, MNNov 26, 1966 · N3520L · Substantial damage NTSB MIA67D0292Accident · No injuriesClosedCessna 150 · Hollywood, FLNov 25, 1966 · N8274S · Substantial damage NTSB SEA67D0201Accident · No injuriesClosedCessna 150 · Colton, WANov 22, 1966 · N8974S · Substantial damage NTSB NYC67D0399Accident · No injuriesClosedCessna 150 · Lincoln Park, NJNov 22, 1966 · N8990S · Substantial damage NTSB LAX67F0128Accident · No injuriesClosedCessna 150 · Pacoima, CANov 21, 1966 · N7166F · Substantial damage NTSB DIA67F0002Accident · Minor injuriesClosedCessna 150F · Hagerstown, MDNov 21, 1966 · N8075S · Substantial damage NTSB MKC67A0035Accident · 1 fatalClosedCessna 150 · Creve Coeur, MONov 20, 1966 · N6791F · Destroyed NTSB MKC67D0334Accident · No injuriesClosedCessna 150F · Jefferson, IANov 19, 1966 · N7996F · Substantial damage NTSB DEN67F0153Accident · No injuriesClosedCessna 150 · Albuquerque, NMNov 19, 1966 · N7931F · Substantial damage NTSB NYC67D0394Accident · No injuriesClosedCessna 150 · Amagansett, NYNov 18, 1966 · N8170F · Substantial damage NTSB MKC67F0287Accident · Serious injuriesClosedCessna 150 · Crystal, MNNov 15, 1966 · N3698S · Destroyed NTSB DEN67D0155Accident · No injuriesClosedCessna 150 · Aurora, CONov 14, 1966 · N8056F · Substantial damage NTSB SEA67D0175Accident · No injuriesClosedCessna 150 · Spokane, WANov 13, 1966 · N8647G · Substantial damage NTSB MIA67F0277Accident · No injuriesClosedCessna 150 · Somerville, TNNov 12, 1966 · N8135F · Substantial damage NTSB MIA67F0272Accident · No injuriesClosedCessna 150 · Icksburg, MSNov 10, 1966 · N7044F · Substantial damage NTSB NYC67F0377Accident · No injuriesClosedCessna 150 · Hiladelphia, PANov 8, 1966 · N8517G · Substantial damage NTSB MIA67F0302Accident · Serious injuriesClosedCessna 150F · Scottsboro, ALNov 6, 1966 · N8163F · Destroyed NTSB SEA67D0177Accident · No injuriesClosedCessna 150 · Twin Falls, IDNov 5, 1966 · N8800S · Substantial damage NTSB DEN67A0031Accident · 2 fatalClosedCessna 150F · Erie, CONov 5, 1966 · N7981F · Destroyed NTSB MIA67F0334Accident · No injuriesClosedCessna 150F · Gainesville, FLNov 2, 1966 · N8758G · Substantial damage NTSB LAX67F0193Accident · No injuriesClosedCessna 150F · Long Beach, CANov 1, 1966 · N7086F · Substantial damage NTSB MKC67D0326Accident · No injuriesClosedCessna 150 · Branson, MOOct 31, 1966 · N7702F · Substantial damage NTSB MIA67D0283Accident · No injuriesClosedCessna 150 · Eufaula, ALOct 30, 1966 · N8312G · Substantial damage NTSB CHI67D0367Accident · Minor injuriesClosedCessna 150 · Kent, OHOct 27, 1966 · N8020F · Destroyed NTSB OAK67D0149Accident · No injuriesClosedCessna 150 · Minden, NVOct 26, 1966 · N6793F · Substantial damage NTSB NYC67D0345Accident · No injuriesClosedCessna 150 · South Norfolk, VAOct 23, 1966 · N6829F · Substantial damage NTSB MIA67F0276Accident · No injuriesClosedCessna 150 · Mobile, ALOct 22, 1966 · N7752F · Substantial damage NTSB FTW67F0276Accident · No injuriesClosedCessna 150 · Portland, TXOct 16, 1966 · N8724G · Substantial damage NTSB NYC67D0312Accident · No injuriesClosedCessna 150 · Franklin, NJOct 15, 1966 · N8122F · Substantial damage NTSB FTW67D0275Accident · No injuriesClosedCessna 150F · Odessa, TXOct 15, 1966 · N6728F · Substantial damage NTSB FTW67D0262Accident · No injuriesClosedCessna 150 · Rogers, AROct 15, 1966 · N7852F · Substantial damage NTSB MKC67F0246Accident · No injuriesClosedCessna 150 · Berkeley, MOOct 14, 1966 · N6678F · Substantial damage NTSB MIA67D0314Accident · No injuriesClosedCessna 150 · Huntsville, ALOct 12, 1966 · N8728S · Substantial damage NTSB OAK67A0042Accident · 1 fatalClosedCessna 150F · Bass Lake, CAOct 9, 1966 · N7847F · Substantial damage NTSB NYC67F0318Accident · No injuriesClosedCessna 150F · Greenfield, MAOct 9, 1966 · N6834F · Substantial damage NTSB MIA67F0219Accident · No injuriesClosedCessna 150 · Ashland City, TNOct 8, 1966 · N8681G · Substantial damage NTSB LAX67D0161Accident · No injuriesClosedCessna 150 · Rialto, CAOct 6, 1966 · N6519F · Substantial damage NTSB DEN67A0026Accident · 1 fatalClosedCessna 150F · Tooele, UTOct 4, 1966 · N7798F · Destroyed NTSB DEN67F0120Accident · No injuriesClosedCessna 150 · Albuquerque, NMOct 3, 1966 · N8228S · Substantial damage NTSB CHI67F0334Accident · No injuriesClosedCessna 150 · Northbrook, ILOct 2, 1966 · N8065F · 2 aircraft · Substantial damage NTSB CHI67D0352Accident · No injuriesClosedCessna 150 · La Farge, WIOct 1, 1966 · N7725F · Substantial damage NTSB MKC67F0272Accident · No injuriesClosedCessna 150F · Rosemount, MNSep 27, 1966 · N8844S · 2 aircraft · Minor damage NTSB LAX67F0145Accident · No injuriesClosedCessna 150 · Descanso, CASep 25, 1966 · N8675S · Substantial damage NTSB MIA67D0260Accident · No injuriesClosedCessna 150 · Hartsville, SCSep 18, 1966 · N8680S · Substantial damage

Back to Cessna 150F