Amateur-built UNKNOWN ENG
NTSB investigations · 2,054
Matched to the registry by N-number and event date, newest first.
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.engine_model_code IN ('99999')
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.engine_model_code IN ('99999')
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 MIA72DLG09Accident · No injuriesClosedBell 47D-1 · Rembert, SCNTSB FTW72AF002Accident · 1 fatalClosedAeronca 7AC · Big Spring, TXNTSB OAK71FVM56Accident · Serious injuriesClosedBeech 35 · San Carlos, CANTSB DEN71DTE13Accident · Minor injuriesClosedPiper PA-12 · Louviers, CONTSB CHI71FEK36Accident · No injuriesClosedCessna 195B · London, OHNTSB ANC71FAA30Accident · No injuriesClosedCessna 180 · Galena, AKNTSB FTW71FPM24Accident · No injuriesClosedAeronca 11AC · Vinita, OKNTSB CHI71FBM20Accident · Serious injuriesClosedPiper J3C-65 · Coldwater, MINTSB SEA71DWA33Accident · No injuriesClosedCessna 140 · Tigard, ORNTSB FTW71DPD44Accident · No injuriesClosedCessna 120 · Weatherford, TXNTSB CHI71FBJ59Accident · No injuriesClosedPiper PA-22 · Lawton, MINTSB MKC71AK045Accident · 2 fatalClosedPiper J3-C · Mcleod, NDNTSB NYC71DFA29Accident · Minor injuriesClosedPiper J3C-65 · Scotia, NYNTSB LAX71FUA31Accident · No injuriesClosedHiller Acft UH12L4 · Fullerton, CANTSB LAX71FUQ33Accident · No injuriesClosedBell 47G · Van Nuys, CANTSB DEN71FQA20Accident · No injuriesClosedBeech E35 · Albuquerque, NMNTSB OAK71FXQ16Accident · Minor injuriesClosedN.American P-51D · Reno, NVNTSB MKC71DCJ07Accident · No injuriesClosedMooney M20C · Sutherland, NENTSB IAD71DKM07Accident · No injuriesClosedLuscombe 8E · Wadesboro, NCNTSB ANC71AA004Accident · No injuriesClosedHiller Acft FH1100 · Chisana, AKNTSB CHI71DBJ01Accident · Minor injuriesClosedStokes Me SF · Midland, MINTSB MKC70FDD16Accident · 1 fatalClosedPiper PA-18 · Lehr, NDNTSB FTW70FPM07Accident · No injuriesClosedAeronca 11AC · Grove, OKNTSB IAD70DID16Accident · Minor injuriesClosedCessna 172 · Hopewell, VANTSB SEA70DVQ02Accident · No injuriesClosedHiller Acft UH-12E · Greenleaf, ORNTSB MKC70FCJ14Accident · No injuriesClosedBeech C35 · Hastings, NENTSB CHI70F0344Accident · Minor injuriesClosedGlobe GC-1B · Wheeling, ILNTSB OAK70F0179Accident · No injuriesClosedStarduster SA-300 · Jean, NVNTSB LAX70F0071Accident · No injuriesClosedNaval Fcty N3N-1 · Litchfld Pk, AZNTSB MIA70D0150Accident · No injuriesClosedAeronca 65-CA · Mount Dora, FLNTSB SEA70F0077Accident · Serious injuriesClosedPuss Moth 80A · Tekoa, WANTSB NYC70D0080Accident · No injuriesClosedAeronca 7KCAB · Hopedale, MANTSB SEA70D0065Accident · No injuriesClosedTravel Air E4000 · Nyssa, ORNTSB DEN70F0070Accident · No injuriesClosedAeronca 7BCM · Clifton, CONTSB MIA70D0016Accident · No injuriesClosedBensen B-8M · Brooksville, FLNTSB LAX69F0365Accident · Minor injuriesClosedTaylor JK-1 · Chino, CANTSB FTW69D0371Accident · No injuriesClosedCessna 182A · Denison, TXNTSB MKC69D0245Accident · No injuriesClosedStinson 108-2 · Sharon Sprgs, KSNTSB MKC69F0223Accident · No injuriesClosedErcoupe 415-C · South Haven, KSNTSB DEN69F0158Accident · Serious injuriesClosedErco 415-C · Montrose, CONTSB OAK69D0088Accident · No injuriesClosedCessna 120 · Oakdale, CANTSB FTW68D0533Accident · No injuriesClosedBoeing A75 · Lake Charles, LANTSB MKC68D0537Accident · No injuriesClosedBeech D95A · Kansas City, MONTSB FTW68D0455Accident · No injuriesClosedPiper PA-24 · Keene, TXNTSB DIA68F0122Accident · No injuriesClosedCessna 310 · Sandston, VANTSB FTW68D0335Accident · No injuriesClosedCessna 180 · Pine Bluff, ARNTSB CHI68D0466Accident · Minor injuriesClosedPiper PA-22 · Gladwin, MINTSB LAX68A0029Accident · No injuriesClosedBell 47D1 · Long Beach, CANTSB MKC68D0214Accident · Minor injuriesClosedCessna 140 · Independence, MONTSB NYC68F0107Accident · No injuriesClosedNavion A · Warwick, NY
Back to Amateur-built UNKNOWN ENG