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 LAX68D0021Accident · No injuriesClosedCessna 150 · Santee, CAJul 2, 1967 · N8150S · Substantial damage NTSB MKC68F0036Accident · No injuriesClosedCessna 150F · St Clair, MOJun 30, 1967 · N6777F · Substantial damage NTSB FTW68D0060Accident · No injuriesClosedCessna 150 · Bowie, TXJun 30, 1967 · N3131X · Substantial damage NTSB OAK68D0103Accident · No injuriesClosedCessna 150 · Minden, NVJun 29, 1967 · N8286S · Substantial damage NTSB CHI68D0193Accident · No injuriesClosedCessna 150 · Naperville, ILJun 29, 1967 · N7028F · Substantial damage NTSB CHI68D0101Accident · No injuriesClosedCessna 150 · Northbrook, ILJun 27, 1967 · N8602G · Substantial damage NTSB MIA68D0068Accident · No injuriesClosedCessna 150 · Brunswick, GAJun 25, 1967 · N6615F · Substantial damage NTSB DEN68F0030Accident · Minor injuriesClosedCessna 150 · Silver City, NMJun 25, 1967 · N8677S · Substantial damage NTSB CHI68D0240Accident · Minor injuriesClosedCessna 150 · Canal Fulton, OHJun 25, 1967 · N6714F · Destroyed NTSB FTW68D0056Accident · No injuriesClosedCessna 150 · Morrilton, ARJun 24, 1967 · N7187F · Substantial damage NTSB DIA68F0007Accident · No injuriesClosedCessna 150 · Waxhaw, NCJun 24, 1967 · N8045S · Substantial damage NTSB FTW68D0042Accident · No injuriesClosedCessna 150 · Abilene, TXJun 22, 1967 · N8892G · Substantial damage NTSB MKC68F0293Accident · No injuriesClosedCessna 150 · St Louis, MOJun 20, 1967 · N3031X · Substantial damage NTSB MKC68D0047Accident · No injuriesClosedCessna 150 · Red Oak, IAJun 19, 1967 · N8106S · Substantial damage NTSB FTW67F0019Accident · No injuriesClosedCessna 150 · Houma, LAJun 19, 1967 · N7150F · Substantial damage NTSB LAX68D0114Accident · No injuriesClosedCessna 150 · Compton, CAJun 18, 1967 · N8231F · Substantial damage NTSB NYC68D0073Accident · No injuriesClosedCessna 150 · Presque Isle, MEJun 17, 1967 · N8208F · Substantial damage NTSB MIA67F0574Accident · No injuriesClosedCessna 150 · Springfield, TNJun 17, 1967 · N8685G · Substantial damage NTSB ANC68F0022Accident · No injuriesClosedCessna 150 · Anchorage, AKJun 15, 1967 · N8805S · Substantial damage NTSB SEA68D0056Accident · No injuriesClosedCessna 150 · Renton, WAJun 9, 1967 · N8799S · Substantial damage NTSB LAX68D0013Accident · No injuriesClosedCessna 150 · Fullerton, CAJun 8, 1967 · N8188S · Substantial damage NTSB FTW68D0012Accident · No injuriesClosedCessna 150F · Geronimo, OKJun 6, 1967 · N3579L · Destroyed NTSB NYC68F0008Accident · No injuriesClosedCessna 150 · Wappinger Fall, NYJun 3, 1967 · N8712G · Substantial damage NTSB OAK67D0339Accident · No injuriesClosedCessna 150 · San Luis Ob, CAJun 2, 1967 · N6744F · Substantial damage NTSB CHI68D0310Accident · No injuriesClosedCessna 150 · East Alton, ILJun 2, 1967 · N6547F · Substantial damage NTSB LAX67D0439Accident · No injuriesClosedCessna 150 · Avalon, CAMay 31, 1967 · N8634S · Substantial damage NTSB NYC67F0697Accident · No injuriesClosedCessna 150 · E.Farmingdale, NYMay 30, 1967 · N8080S · Substantial damage NTSB MIA67D0559Accident · No injuriesClosedCessna 150F · Ashland, ALMay 30, 1967 · N3081X · Substantial damage NTSB DIA68F0002Accident · Minor injuriesClosedCessna 150 · Michellville, MDMay 29, 1967 · N8692S · Substantial damage NTSB MKC68F0254Accident · No injuriesClosedCessna 150 · Taylor, MOMay 24, 1967 · N6519F · Substantial damage NTSB CHI68F0032Accident · No injuriesClosedCessna 150 · Freeland, MIMay 24, 1967 · N8687G · Substantial damage NTSB NYC67D0698Accident · No injuriesClosedCessna 150 · Deer Park, NYMay 23, 1967 · N8290S · Substantial damage NTSB SEA68D0052Accident · Serious injuriesClosedCessna 150 · Albany, ORMay 21, 1967 · N8727G · No damage NTSB LAX67A0107Accident · 2 fatalClosedCessna 150F · Hawthorne, CAMay 21, 1967 · N7826F · 2 aircraft · Destroyed NTSB FTW67D0665Accident · No injuriesClosedCessna 150 · Corpus Chrsti, TXMay 21, 1967 · N6867F · Substantial damage NTSB OAK68D0007Accident · No injuriesClosedCessna 150 · Tulare, CAMay 20, 1967 · N6540F · Substantial damage NTSB OAK67D0303Accident · No injuriesClosedCessna 150 · Olancha, CAMay 20, 1967 · N6645F · Substantial damage NTSB FTW67D0620Accident · No injuriesClosedCessna 150 · Anneta, TXMay 19, 1967 · N6238R · Substantial damage NTSB MIA67D0036Accident · No injuriesClosedCessna 150 · Dublin, GAMay 15, 1967 · N8154S · Substantial damage NTSB DEN67D0280Accident · No injuriesClosedCessna 150 · Ft Morgan, COMay 14, 1967 · N8029F · Substantial damage NTSB LAX67D0406Accident · No injuriesClosedCessna 150 · Huntingtn B, CAMay 12, 1967 · N7086F · Substantial damage NTSB DIA67F0106Accident · Serious injuriesClosedCessna 150 · Chapel Hill, NCMay 10, 1967 · N8304G · Destroyed NTSB OAK68D0006Accident · No injuriesClosedCessna 150 · Fresno, CAMay 9, 1967 · N8688S · Substantial damage NTSB LAX67D0401Accident · No injuriesClosedCessna 150 · Coachella, CAMay 9, 1967 · N8856S · Substantial damage NTSB SEA67A0063Accident · 1 fatalClosedCessna 150 · Bremerton, WAMay 8, 1967 · N7077F · Destroyed NTSB CHI67D0660Accident · No injuriesClosedCessna 150 · Waukesha, WIMay 7, 1967 · N3589L · Substantial damage NTSB LAX67D0397Accident · No injuriesClosedCessna 150 · Santee, CAMay 6, 1967 · N6729F · Substantial damage NTSB NYC67F0635Accident · No injuriesClosedCessna 150 · Farmingdale, NYMay 5, 1967 · N6443F · Substantial damage NTSB MKC67D0574Accident · No injuriesClosedCessna 150 · Fortescue, MOMay 4, 1967 · N8050S · Substantial damage NTSB MIA67F0504Accident · No injuriesClosedCessna 150F · Opa Locka, FLMay 4, 1967 · N8658S · Substantial damage

Back to Cessna 150F