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 MIA78DKJ30Accident · Minor injuriesClosedBellanca 7KCAB · Wetumpka, ALApr 9, 1978 · N1131E · DestroyedNTSB MIA78FKQ05Accident · No injuriesClosedN.American P-51 · Ellisville, MSFeb 15, 1978 · N117E · Substantial damageNTSB MIA78FLD21Accident · 1 fatalClosedHolt PDQ2 · Arcadia, FLJan 29, 1978 · N30CH · DestroyedNTSB IAD78IA036Incident · No injuriesClosedBeech TC45J · Norfolk, VAJan 25, 1978 · N231LJ · Minor damageNTSB IAD78DKM05Accident · No injuriesClosedBeech B23 · Sophia, NCJan 12, 1978 · N2325J · Substantial damageNTSB MKC78DCG10Accident · No injuriesClosedTerrill SPEC-L · Kimberling, MONov 18, 1977 · N3622G · Substantial damageNTSB FTW78DPG06Accident · No injuriesClosedMustang II · Wheatley, ARNov 13, 1977 · N18811 · Substantial damageNTSB OAK78DVG02Accident · No injuriesClosedMooney M-20B · Georgetown, CAOct 21, 1977 · N123L · Substantial damageNTSB OAK77DVG66Accident · Minor injuriesClosedHome Built KR1 · Redding, CASep 15, 1977 · N9HD · Substantial damageNTSB IAD77FIA23Accident · Serious injuriesClosedChampion 7ACA · Brandywine, MDAug 28, 1977 · N9110L · Substantial damageNTSB CHI77DEE55Accident · No injuriesClosedBrantly 305 · Wheeling, ILAug 17, 1977 · N16616 · Substantial damageNTSB SEA77DYP40Accident · No injuriesClosedGrumman G-164B · Quincy, WAAug 15, 1977 · N48423 · Substantial damageNTSB MKC77DER74Accident · No injuriesClosedPietenpol-A Scout · Mankato, MNAug 6, 1977 · N5987 · Substantial damageNTSB CHI77FA062Accident · 1 fatalClosedBellanca 7ACA · Oshkosh, WIAug 1, 1977 · N12204 · 2 aircraft · DestroyedNTSB SEA77DYA27Accident · No injuriesClosedHughes 269C · Gooding, IDJul 5, 1977 · N7432F · DestroyedNTSB MIA77DLG20Accident · No injuriesClosedBell 47D · Oswego, SCJun 25, 1977 · N586T · Substantial damageNTSB LAX77FUG43Accident · No injuriesClosedScorpion TOO · Corona, CAJun 18, 1977 · N656F · Substantial damageNTSB CHI77FEM25Accident · No injuriesClosedPiper PA36 · Grant, MIMay 17, 1977 · N57588 · Substantial damageNTSB SEA77FYK06Accident · No injuriesClosedStinson 108 · Burns, ORMay 14, 1977 · N65127 · 2 aircraft · No damageNTSB MKC77DCJ48Accident · No injuriesClosedSportavia RF4-D · Central City, NEApr 28, 1977 · N7723 · Substantial damageNTSB MIA77FLD50Accident · Minor injuriesClosedSikorsky H19E · Lady Lake, FLApr 15, 1977 · N95760 · Substantial damageNTSB OAK77DXQ16Accident · No injuriesClosedSchneider ES-60 · Fernley, NVApr 7, 1977 · N8161 · Substantial damageNTSB DEN77FTE25Accident · No injuriesClosedPiper PA-24 · Eckley, COMar 7, 1977 · N8866P · Substantial damageNTSB OAK77FA019Accident · 1 fatalClosedBoeing B75N1 · Jean, NVFeb 19, 1977 · N65543 · DestroyedNTSB MIA77FLD17Accident · No injuriesClosedBirdman TL-1 · Deland, FLNov 18, 1976 · N27260 · Substantial damageNTSB FTW77DRA01Accident · No injuriesClosedDemoiselle A · Columbus, TXOct 30, 1976 · N65269 · DestroyedNTSB NYC77FFA01Accident · No injuriesClosedBell 47G-2 · Utica, NYOct 6, 1976 · N73550 · Substantial damageNTSB CHI77FEM01Accident · No injuriesClosedJeanies Teenie · Frankfort, MIOct 2, 1976 · N519S · DestroyedNTSB DEN76DQD34Accident · Minor injuriesClosedCessna 188A · Hatch, NMSep 9, 1976 · N5643J · Substantial damageNTSB FTW76DRG85Accident · Minor injuriesClosedBucker BU-133 · Cibolo, TXAug 22, 1976 · N1940H · Substantial damageNTSB MKC76FCA39Accident · No injuriesClosedBell 47J · St Louis, MOAug 7, 1976 · N5154B · Substantial damageNTSB MKC76FCJ56Accident · No injuriesClosedPiper PA-36 · Imperial, NEJul 29, 1976 · N57594 · Substantial damageNTSB CHI76FEE69Accident · No injuriesClosedSportster HA-2M · Rockford, ILJul 29, 1976 · N158 · Substantial damageNTSB FTW76DPD51Accident · No injuriesClosedPiper PA-36 · Gilliland, TXJul 17, 1976 · N57600 · Substantial damageNTSB SEA76DYA39Accident · No injuriesClosedHughes 269A · Gooding, IDJul 10, 1976 · N7432F · Substantial damageNTSB LAX76DUG63Accident · Serious injuriesClosedWestfall Sport · Murrietta, CAJun 27, 1976 · N3373 · Substantial damageNTSB FTW76FQG81Accident · Serious injuriesClosedPiper PA-36 · Earth, TXJun 19, 1976 · N57597 · Substantial damageNTSB OAK76FVD40Accident · Serious injuriesClosedHutchinson EH-1 · Stockton, CAJun 14, 1976 · N711EH · Substantial damageNTSB OAK76DVW26Accident · No injuriesClosedBeech V35 · Furnace Creek, CAMay 14, 1976 · N499DS · Substantial damageNTSB OAK76FXQ39Accident · No injuriesClosedBede BD-5 · Reno, NVMay 3, 1976 · N733ST · Substantial damageNTSB LAX76FUA22Accident · 1 fatalClosedBirdman TL-1 · Anaheim, CAMay 3, 1976 · N101BA · DestroyedNTSB LAX76DVG40Accident · Minor injuriesClosedScorpion TWO · Corona, CAMar 14, 1976 · N7043 · Substantial damageNTSB LAX76DUM23Accident · No injuriesClosedScorpion TOO · San Diego, CAMar 12, 1976 · N525BG · Substantial damageNTSB MIA76AM065Accident · No injuriesClosedCessna 172 · Ormond Beach, FLFeb 20, 1976 · N20846 · 2 aircraft · Substantial damageNTSB OAK76FJA08Accident · No injuriesClosedMurrayair MA-1 · Hilo, HIDec 9, 1975 · N1015Y · Substantial damageNTSB DEN76FQA22Accident · Minor injuriesClosedBernardin MS-2 · Albuquerque, NMOct 18, 1975 · N4956E · Substantial damageNTSB FTW76AF023Accident · Serious injuriesClosedDouglas DC-8 · Texico Vortac, TXSep 22, 1975 · N808E · No damageNTSB SEA76FYE13Accident · No injuriesClosedDehavilland DHC-3 · Auburn, WASep 4, 1975 · N567AA · Substantial damageNTSB LAX7LDUQ07|LAX76DUQ07Accident · No injuriesClosedPitts Spcl S1C · Lompoc, CAAug 22, 1975 · N18CB · 2 aircraft · Substantial damageNTSB CHI76DEC05Accident · No injuriesClosedDehavilland DH-82A · Otisville, MIAug 10, 1975 · N9TM · Substantial damage
Back to Amateur-built UNKNOWN ENG