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.

NTSB MIA72DLG09Accident · No injuriesClosedBell 47D-1 · Rembert, SCAug 20, 1971 · N586T · Substantial damageNTSB FTW72AF002Accident · 1 fatalClosedAeronca 7AC · Big Spring, TXJul 6, 1971 · N84600 · DestroyedNTSB OAK71FVM56Accident · Serious injuriesClosedBeech 35 · San Carlos, CAJun 19, 1971 · N3934N · Substantial damageNTSB DEN71DTE13Accident · Minor injuriesClosedPiper PA-12 · Louviers, COJun 4, 1971 · N3364M · Substantial damageNTSB CHI71FEK36Accident · No injuriesClosedCessna 195B · London, OHMay 18, 1971 · N2134C · Substantial damageNTSB ANC71FAA30Accident · No injuriesClosedCessna 180 · Galena, AKMay 18, 1971 · N91290 · Substantial damageNTSB FTW71FPM24Accident · No injuriesClosedAeronca 11AC · Vinita, OKMay 3, 1971 · N85928 · Substantial damageNTSB CHI71FBM20Accident · Serious injuriesClosedPiper J3C-65 · Coldwater, MIApr 3, 1971 · N1416N · DestroyedNTSB SEA71DWA33Accident · No injuriesClosedCessna 140 · Tigard, ORApr 1, 1971 · N76294 · Substantial damageNTSB FTW71DPD44Accident · No injuriesClosedCessna 120 · Weatherford, TXMar 10, 1971 · N77176 · Substantial damageNTSB CHI71FBJ59Accident · No injuriesClosedPiper PA-22 · Lawton, MIMar 3, 1971 · N2529A · Substantial damageNTSB MKC71AK045Accident · 2 fatalClosedPiper J3-C · Mcleod, NDFeb 10, 1971 · N92429 · DestroyedNTSB NYC71DFA29Accident · Minor injuriesClosedPiper J3C-65 · Scotia, NYDec 19, 1970 · N92635 · Substantial damageNTSB LAX71FUA31Accident · No injuriesClosedHiller Acft UH12L4 · Fullerton, CADec 8, 1970 · N86690 · Substantial damageNTSB LAX71FUQ33Accident · No injuriesClosedBell 47G · Van Nuys, CAOct 20, 1970 · N4702S · Substantial damageNTSB DEN71FQA20Accident · No injuriesClosedBeech E35 · Albuquerque, NMOct 12, 1970 · N7352B · Substantial damageNTSB OAK71FXQ16Accident · Minor injuriesClosedN.American P-51D · Reno, NVSep 18, 1970 · N79111 · Substantial damageNTSB MKC71DCJ07Accident · No injuriesClosedMooney M20C · Sutherland, NEJul 23, 1970 · N78874 · Substantial damageNTSB IAD71DKM07Accident · No injuriesClosedLuscombe 8E · Wadesboro, NCJul 19, 1970 · N25295 · Substantial damageNTSB ANC71AA004Accident · No injuriesClosedHiller Acft FH1100 · Chisana, AKJul 12, 1970 · N5049F · Substantial damageNTSB CHI71DBJ01Accident · Minor injuriesClosedStokes Me SF · Midland, MIJul 5, 1970 · N4677T · Substantial damageNTSB MKC70FDD16Accident · 1 fatalClosedPiper PA-18 · Lehr, NDJun 19, 1970 · N3281Z · DestroyedNTSB FTW70FPM07Accident · No injuriesClosedAeronca 11AC · Grove, OKMay 16, 1970 · N85928 · Substantial damageNTSB IAD70DID16Accident · Minor injuriesClosedCessna 172 · Hopewell, VAApr 18, 1970 · N7626X · Substantial damageNTSB SEA70DVQ02Accident · No injuriesClosedHiller Acft UH-12E · Greenleaf, ORApr 4, 1970 · N5381V · DestroyedNTSB MKC70FCJ14Accident · No injuriesClosedBeech C35 · Hastings, NEMar 7, 1970 · N667D · Substantial damageNTSB CHI70F0344Accident · Minor injuriesClosedGlobe GC-1B · Wheeling, ILOct 23, 1969 · N78172 · Substantial damageNTSB OAK70F0179Accident · No injuriesClosedStarduster SA-300 · Jean, NVSep 13, 1969 · N2552 · Substantial damageNTSB LAX70F0071Accident · No injuriesClosedNaval Fcty N3N-1 · Litchfld Pk, AZAug 21, 1969 · N45280 · DestroyedNTSB MIA70D0150Accident · No injuriesClosedAeronca 65-CA · Mount Dora, FLAug 7, 1969 · N31417 · Substantial damageNTSB SEA70F0077Accident · Serious injuriesClosedPuss Moth 80A · Tekoa, WAAug 3, 1969 · N223EC · Substantial damageNTSB NYC70D0080Accident · No injuriesClosedAeronca 7KCAB · Hopedale, MAJul 31, 1969 · N5063X · Substantial damageNTSB SEA70D0065Accident · No injuriesClosedTravel Air E4000 · Nyssa, ORJul 28, 1969 · N477N · Substantial damageNTSB DEN70F0070Accident · No injuriesClosedAeronca 7BCM · Clifton, COJun 29, 1969 · N2704E · Substantial damageNTSB MIA70D0016Accident · No injuriesClosedBensen B-8M · Brooksville, FLMay 18, 1969 · N1074 · Substantial damageNTSB LAX69F0365Accident · Minor injuriesClosedTaylor JK-1 · Chino, CAMay 10, 1969 · N8011 · Substantial damageNTSB FTW69D0371Accident · No injuriesClosedCessna 182A · Denison, TXJan 22, 1969 · N3953D · Substantial damageNTSB MKC69D0245Accident · No injuriesClosedStinson 108-2 · Sharon Sprgs, KSOct 29, 1968 · N9807K · Substantial damageNTSB MKC69F0223Accident · No injuriesClosedErcoupe 415-C · South Haven, KSOct 28, 1968 · N37139 · Substantial damageNTSB DEN69F0158Accident · Serious injuriesClosedErco 415-C · Montrose, COOct 13, 1968 · N93542 · Substantial damageNTSB OAK69D0088Accident · No injuriesClosedCessna 120 · Oakdale, CAJul 30, 1968 · N77176 · Substantial damageNTSB FTW68D0533Accident · No injuriesClosedBoeing A75 · Lake Charles, LAApr 19, 1968 · N46888 · Substantial damageNTSB MKC68D0537Accident · No injuriesClosedBeech D95A · Kansas City, MOApr 16, 1968 · N8613M · Substantial damageNTSB FTW68D0455Accident · No injuriesClosedPiper PA-24 · Keene, TXFeb 23, 1968 · N8866P · Substantial damageNTSB DIA68F0122Accident · No injuriesClosedCessna 310 · Sandston, VANov 26, 1967 · N3762D · Substantial damageNTSB FTW68D0335Accident · No injuriesClosedCessna 180 · Pine Bluff, ARNov 13, 1967 · N3232D · Substantial damageNTSB CHI68D0466Accident · Minor injuriesClosedPiper PA-22 · Gladwin, MIOct 29, 1967 · N1641A · Substantial damageNTSB LAX68A0029Accident · No injuriesClosedBell 47D1 · Long Beach, CASep 8, 1967 · N74119 · Substantial damageNTSB MKC68D0214Accident · Minor injuriesClosedCessna 140 · Independence, MOAug 24, 1967 · N76939 · Substantial damageNTSB NYC68F0107Accident · No injuriesClosedNavion A · Warwick, NYAug 5, 1967 · N91140 · Substantial damage
Back to Amateur-built UNKNOWN ENG