Query with SQL
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 ('7100502')
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 ('7100502')
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESCRun 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 CEN10CA263Accident · No injuriesData collectionFinal reportPiper J-3 · Parker, COThe pilot's failure to maintain control of the airplane while landing in gusting winds.NTSB MIA96LA217Accident · No injuriesLimited investigationFinal reportPiper J3 · Aiken, SCthe pilot's improper flare, which resulted in a hard landing; and his loss of directional control, which was followed by impact with trees.NTSB ATL92LA027Accident · Minor injuriesLimited investigationFinal reportPiper J-3 · Statesville, NCLoss of engine power for undetermined reasons. A factor was the lack of a suitable landing site.NTSB FTW79FQG33Accident · No injuriesClosedPiper J-3 · Shallowater, TXNTSB FTW78FPA02Accident · 2 fatalClosedPiper J3C-65 · Terrell, TXNTSB MIA77FKG57Accident · Minor injuriesClosedPiper J-3 · Athens, GANTSB NYC76DFA20Accident · No injuriesClosedPiper J-3 · Cambridge, NYNTSB DEN76DTE33Accident · No injuriesClosedPiper J-3 · Aurora, CONTSB SEA75AS040Accident · 1 fatalClosedPiper J-3 · Missing AircraftNTSB FTW75FPJ11Accident · Serious injuriesClosedPiper J-3 · Fairview, OKNTSB IAD74DKM50Accident · No injuriesClosedPiper J-3 · Charlotte, NCNTSB MIA72DKJ16Accident · No injuriesClosedPiper J-3 · Courtland, ALNTSB SEA70DWD18Accident · Minor injuriesClosedPiper J-3 · Bellingham, WANTSB MIA70D0120Accident · No injuriesClosedPiper J3C-65 · Cocoa, FLNTSB CHI69A0008Accident · 1 fatalClosedPiper J3L · Sullivan, ILNTSB MKC69F0095Accident · Minor injuriesClosedPiper J3C · Austin, MNNTSB MIA69D0024Accident · Minor injuriesClosedPiper J-3 · Shelby, MSNTSB LAX68A0101Accident · 4 fatalClosedPiper J-3 · Bakersfield, CANTSB NYC68D0429Accident · Minor injuriesClosedPiper J-3 · Exico, NYNTSB SEA68F0072Accident · No injuriesClosedPiper J-3 · Bellevue, WANTSB NYC67F0645Accident · Minor injuriesClosedPiper J-3 · Amityville, NYNTSB MIA67D0531Accident · No injuriesClosedPiper J-3 · Merritt Isle, FLNTSB FTW67D0497Accident · No injuriesClosedPiper J-3C · Colony, OKNTSB MIA67A0013Accident · 1 fatalClosedPiper J-3 · Hernando, MSNTSB CHI67F0228Accident · Minor injuriesClosedPiper J3C · Wheeling, ILNTSB CHI66F0707Accident · No injuriesClosedPiper J3 · Grand Ledge, MINTSB CHI66A0049Accident · 1 fatalClosedPiper J-3 · New Carlisle, OHNTSB CHI66D0417Accident · No injuriesClosedPiper J-3 · Half Day, ILNTSB NYC66D0345Accident · No injuriesClosedPiper J3C · Butler, PANTSB MKC66F0111Accident · Minor injuriesClosedPiper J3 · Eagleville, MONTSB NYC65F0058Accident · Serious injuriesClosedPiper J3C-65 · New Kent, VANTSB UNK64X3631Accident · No injuriesClosedPiper J3 · Copperscove, TXNTSB UNK64X3390Accident · No injuriesClosedPiper J3 · Linn Grove, INNTSB UNK64X2469Accident · No injuriesClosedPiper J3C · Fairwell Lke, AKNTSB UNK64X0986Accident · 1 fatalClosedPiper J3C · Pelham, NC
Back to Piper J-3