Skip to content

NTSB investigations · 109

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 ('0540102') 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 ('0540102')
  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 ('0540102')
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 NYC72FKM11Accident · Serious injuriesClosedAlon A-2 · Hickory, NCOct 8, 1971 · N5486E · Substantial damage NTSB MKC71FCG43Accident · Minor injuriesClosedAlon A-2 · Topeka, KSFeb 6, 1971 · N6578Q · Substantial damage NTSB LAX71DUJ54Accident · No injuriesClosedMooney A2A · Tucson, AZJan 1, 1971 · N6371V · Substantial damage NTSB DEN71DQA24Accident · No injuriesClosedAlon A-2 · Los Lunas, NMOct 28, 1970 · N6369V · Substantial damage NTSB FTW71AF010Accident · 3 fatalClosedAlon A-2 · Plainview, TXSep 11, 1970 · N6577Q · 2 aircraft · Destroyed NTSB IAD71FID03Accident · No injuriesClosedAlon A-2 · Disputanta, VAJul 20, 1970 · N6594Q · Substantial damage NTSB MKC70DCD41Accident · Minor injuriesClosedAlon A-2 · Osceola, IAJun 22, 1970 · N6591Q · Destroyed NTSB IAD70DID22Accident · Minor injuriesClosedAlon A-2 · Hopewell, VAJun 22, 1970 · N6597Q · Substantial damage NTSB SEA70FDG05Accident · No injuriesClosedAlon A-2 · Great Falls, MTMay 23, 1970 · N5697F · Substantial damage NTSB NYC70D0200Accident · Minor injuriesClosedAlon A-2 · Ticonderoga, NYOct 18, 1969 · N5657F · Substantial damage NTSB IAD70D0095Accident · No injuriesClosedAlon A-2 · Franklin, VAOct 4, 1969 · N6594Q · Substantial damage NTSB ANC70F0088Accident · No injuriesClosedAlon A-2 · Anchorage, AKOct 4, 1969 · N6537Q · Substantial damage NTSB MKC70D0188Accident · Minor injuriesClosedAlon A-2 · Maryville, MOJul 23, 1969 · N6588Q · Substantial damage NTSB CHI69F0656Accident · Serious injuriesClosedAlon A-2 · Troy, MIMay 28, 1969 · N6356V · Substantial damage NTSB CHI69D0635Accident · No injuriesClosedAlon A-2 · Orland Park, ILApr 7, 1969 · N5491E · Substantial damage NTSB DIA69F0176Accident · No injuriesClosedAlon A-2 · Jacksonville, NCApr 5, 1969 · N5475E · Substantial damage NTSB CHI69F0515Accident · Minor injuriesClosedAlon A-2 · Hinsdale, ILFeb 11, 1969 · N5665F · Substantial damage NTSB LAX69D0228Accident · No injuriesClosedAlon A-2 · Riverside, CAJan 3, 1969 · N5698F · Substantial damage NTSB LAX69A0029Accident · 1 fatalClosedAlon A-2 · Lockwood, CANov 27, 1968 · N5469E · Substantial damage NTSB MIA69D0292Accident · No injuriesClosedAlon A-2 · Vero Beach, FLNov 9, 1968 · N5652F · Substantial damage NTSB MIA69F0106Accident · No injuriesClosedAlon A-2 · Tampa, FLAug 25, 1968 · N5691F · Substantial damage NTSB NYC69D0096Accident · No injuriesClosedAlon A-2 · Ellington, CTAug 2, 1968 · N5608F · Substantial damage NTSB LAX69F0066Accident · 1 fatalClosedAlon A-2 · Carefree, AZJul 22, 1968 · N5667F · Destroyed NTSB SEA68F0300Accident · Serious injuriesClosedAlon A-2 · Billings, MTApr 29, 1968 · N6504Q · Substantial damage NTSB MKC68D0487Accident · No injuriesClosedAlon A-2 · Fort Scott, KSMar 2, 1968 · N5665F · Substantial damage NTSB DIA68D0162Accident · No injuriesClosedAlon A-2 · Jacksonville, NCFeb 17, 1968 · N5475E · Substantial damage NTSB NYC68F0341Accident · No injuriesClosedAlon A-2 · Hyannis, MAJan 9, 1968 · N6570Q · Substantial damage NTSB DEN68D0156Accident · Minor injuriesClosedAlon A-2 · Torreon, NMNov 11, 1967 · N6370V · Substantial damage NTSB LAX68F0165Accident · Minor injuriesClosedAlon A-2 · El Monte, CAOct 6, 1967 · N6585Q · Substantial damage NTSB FTW68D0216Accident · No injuriesClosedAlon A-2 · Port Aransas, TXAug 28, 1967 · N5615F · Substantial damage NTSB DEN68F0056Accident · No injuriesClosedAlon A-2 · Erie, COAug 11, 1967 · N5485E · Destroyed NTSB OAK68D0343Accident · No injuriesClosedAlon A-2 · Las Vegas, NVAug 8, 1967 · N5473E · Substantial damage NTSB FTW68F0150Accident · Minor injuriesClosedAlon A-2 · Fabens, TXAug 8, 1967 · N6599Q · Substantial damage NTSB CHI68D0517Accident · No injuriesClosedAlon A-2 · Litchfield, ILJul 14, 1967 · N5666F · Substantial damage NTSB DIA68F0022Accident · Minor injuriesClosedAlon A-2 · Whitsett, NCJul 7, 1967 · N6566Q · Substantial damage NTSB MKC68D0076Accident · No injuriesClosedAlon A-2 · Finlayson, MNJul 4, 1967 · N6525Q · Substantial damage NTSB CHI68D0114Accident · No injuriesClosedAlon A2 · Grantsburg, WIJun 20, 1967 · N6363V · Substantial damage NTSB MKC68D0005Accident · No injuriesClosedAlon A-2 · Shenandoah, IAJun 4, 1967 · N6588Q · Substantial damage NTSB FTW67F0642Accident · Minor injuriesClosedAlon A-2 · Littlefield, TXMay 24, 1967 · N6558Q · Substantial damage NTSB MKC67D0596Accident · No injuriesClosedAlon A-2 · Wichita, KSMay 17, 1967 · N5611F · Substantial damage NTSB DEN67D0232Accident · No injuriesClosedAlon A2 · Corona, NMMar 13, 1967 · N6371V · Substantial damage NTSB DIA67F0036Accident · Minor injuriesClosedAlon A-2 · Chesapeake, VAFeb 8, 1967 · N6581Q · Substantial damage NTSB FTW67F0352Accident · No injuriesClosedAlon A-2 · El Paso, TXNov 24, 1966 · N6596Q · Substantial damage NTSB NYC67F0352Accident · No injuriesClosedAlon A-2 · Deale, MDNov 13, 1966 · N5616F · Substantial damage NTSB FTW67D0279Accident · No injuriesClosedAlon A-2 · Corning, AROct 22, 1966 · N5655F · Substantial damage NTSB MIA67F0147Accident · No injuriesClosedAlon A-2 · Jacksonville, NCSep 4, 1966 · N5475E · Substantial damage NTSB MKC67D0186Accident · No injuriesClosedAlon A-2 · Silver Bay, MNAug 26, 1966 · N6552Q · Substantial damage NTSB MIA67D0088Accident · Minor injuriesClosedAlon A-2 · Washington, NCJul 23, 1966 · N5486E · Substantial damage NTSB NYC67D0056Accident · No injuriesClosedAlon A-2 · Hopewell, VAJul 9, 1966 · N6506Q · Substantial damage NTSB DEN67D0008Accident · No injuriesClosedAlon A-2 · Pueblo, COJun 18, 1966 · N6534Q · Substantial damage

Back to Alon A2