Skip to content

NTSB investigations · 1,195

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 ('7100510') 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 ('7100510')
  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 ('7100510')
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 DIA67D0026Accident · No injuriesClosedPiper J3C-65 · Hopewell, VAFeb 4, 1967 · N70449 · Substantial damage NTSB MKC67D0407Accident · No injuriesClosedPiper J3C-65 · Gordon, NEJan 27, 1967 · N3423N · Substantial damage NTSB NYC67D0489Accident · No injuriesClosedPiper J3 · Sewell, NJJan 22, 1967 · N7496H · 2 aircraft · Minor damage NTSB DIA67F0017Accident · No injuriesClosedPiper J3C-65 · Huntersville, NCJan 15, 1967 · N23438 · Substantial damage NTSB MKC67D0386Accident · No injuriesClosedPiper J3C-65 · Silver Creek, NEDec 29, 1966 · N6637H · Substantial damage NTSB FTW67F0345Accident · Minor injuriesClosedPiper J3C-65 · Tulsa, OKDec 10, 1966 · N56274 · Substantial damage NTSB NYC67F0391Accident · No injuriesClosedPiper J3C-65 · Farmington, MEDec 4, 1966 · N25972 · Substantial damage NTSB FTW67F0339Accident · Minor injuriesClosedPiper J3C-65 · Stuttgart, ARNov 29, 1966 · N77565 · Substantial damage NTSB NYC67A0088Accident · 1 fatalClosedPiper J3C-65 · Millis, MANov 24, 1966 · N88669 · Destroyed NTSB MIA67D0312Accident · No injuriesClosedPiper L-4 · Guntersville, ALNov 24, 1966 · N42933 · Substantial damage NTSB MKC67D0285Accident · No injuriesClosedPiper J-3 · Bonner Sprgs, KSNov 21, 1966 · N27020 · Substantial damage NTSB NYC67D0329Accident · No injuriesClosedPiper J3C-65 · Agawam, MANov 1, 1966 · N70596 · Substantial damage NTSB MIA67F0308Accident · Serious injuriesClosedPiper J3C-65 · Naples, FLOct 22, 1966 · N3515K · Destroyed NTSB MIA67F0232Accident · No injuriesClosedPiper J-3 · Whiteville, TNOct 8, 1966 · N88533 · Substantial damage NTSB MIA67F0188Accident · No injuriesClosedPiper J-3 · Clarksdale, MSOct 1, 1966 · N92627 · Substantial damage NTSB MIA67D0242Accident · Minor injuriesClosedPiper J-3 · Florence, ALSep 24, 1966 · N98069 · Substantial damage NTSB FTW67A0039Accident · 1 fatalClosedPiper J-3 · Kaplan, LASep 23, 1966 · N98571 · Destroyed NTSB DEN67D0111Accident · No injuriesClosedPiper J-3 · Riverton, WYSep 18, 1966 · N88661 · Substantial damage NTSB MKC67A0023Accident · 1 fatalClosedPiper J3C-65 · Faith, SDSep 14, 1966 · N87964 · Destroyed NTSB MKC67F0201Accident · No injuriesClosedPiper J-3 · Bagley, MNSep 11, 1966 · N98502 · Substantial damage NTSB CHI67A0040Accident · 1 fatalClosedPiper J-3 · Columbia, ILSep 11, 1966 · N98494 · Destroyed NTSB DEN67D0105Accident · Serious injuriesClosedPiper J-3 · Center, COSep 9, 1966 · N70875 · Destroyed NTSB MIA67F0161Accident · No injuriesClosedPiper J3C-65 · Fort Payne, ALSep 7, 1966 · N32612 · Substantial damage NTSB MIA67F0157Accident · No injuriesClosedPiper J3C-65 · Sanford, NCSep 5, 1966 · N91998 · Substantial damage NTSB MIA67D0165Accident · No injuriesClosedPiper J3C · Shelby, MSAug 31, 1966 · N78405 · Substantial damage NTSB MIA67F0226Accident · Serious injuriesClosedPiper J3C-65 · Millen, GAAug 22, 1966 · N98711 · Substantial damage NTSB LAX67D0086Accident · No injuriesClosedPiper J-3 · Santa Paula, CAAug 21, 1966 · N70238 · Substantial damage NTSB MIA67F0176Accident · Minor injuriesClosedPiper J3 · Roberta, GAAug 18, 1966 · N7218H · Substantial damage NTSB MIA67D0143Accident · No injuriesClosedPiper J-3 · Newberry, SCAug 8, 1966 · N42595 · Substantial damage NTSB ANC67D0017Accident · No injuriesClosedPiper J-3 · Nome, AKAug 6, 1966 · N92211 · Substantial damage NTSB CHI67F0171Accident · Minor injuriesClosedPiper J3C-65 · Yates City, ILAug 1, 1966 · N6379H · Destroyed NTSB NYC67D0128Accident · Minor injuriesClosedPiper J3C-65 · Cheshire, MAJul 31, 1966 · N88179 · Substantial damage NTSB MIA67A0008Accident · 1 fatalClosedPiper J3C-65 · Burlington, NCJul 17, 1966 · N2147M · Destroyed NTSB FTW67F0095Accident · Minor injuriesClosedPiper J-3 · Tomball, TXJul 16, 1966 · N75088 · Substantial damage NTSB NYC67A0013Accident · 2 fatalClosedPiper J3C-65 · Clarion, PAJul 15, 1966 · N32916 · Destroyed NTSB NYC67D0080Accident · No injuriesClosedPiper J-3 · Erma, NJJul 11, 1966 · N46286 · Substantial damage NTSB NYC67F0191Accident · Minor injuriesClosedPiper J-3 · West Seneca, NYJul 10, 1966 · N46489 · Substantial damage NTSB NYC67F0032Accident · No injuriesClosedPiper J365 · Ft Kent, MEJul 10, 1966 · N30779 · Substantial damage NTSB CHI67F0076Accident · No injuriesClosedPiper J-3 · Dagget, MIJul 10, 1966 · N6240H · Substantial damage NTSB CHI67D0071Accident · No injuriesClosedPiper J3C-65 · Lawrencevile, OHJul 10, 1966 · N88483 · Substantial damage NTSB CHI67D0074Accident · No injuriesClosedPiper J-3 · Columbia, KYJul 9, 1966 · N6104H · Substantial damage NTSB FTW67A0004Accident · 1 fatalClosedPiper J-3 · Stuttgart, ARJul 6, 1966 · N42418 · Destroyed NTSB MIA67F0005Accident · No injuriesClosedPiper J3 · Erwin, NCJul 4, 1966 · N42463 · Substantial damage NTSB OAK67D0037Accident · No injuriesClosedPiper J-3C · Hanford, CAJul 3, 1966 · N6741H · Substantial damage NTSB FTW67A0002Accident · 1 fatalClosedPiper J3C · Memphis, TXJul 3, 1966 · N42743 · Destroyed NTSB SEA67F0082Accident · No injuriesClosedPiper J3C-65 · Beavercreek, ORJun 28, 1966 · N48612 · Substantial damage NTSB FTW67D0061Accident · Minor injuriesClosedPiper J3 · Muleshoe, TXJun 23, 1966 · N30797 · Substantial damage NTSB MKC67F0046Accident · No injuriesClosedPiper J3C-65 · Regent, NDJun 19, 1966 · N42277 · Substantial damage NTSB MKC67F0034Accident · Serious injuriesClosedPiper J3C · New England, NDJun 19, 1966 · N37916 · Substantial damage NTSB MKC67F0081Accident · Serious injuriesClosedPiper J-3 · Bonilla, SDJun 14, 1966 · N98098 · Destroyed

Back to Piper J3C-65