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 MIA78DKJ30Accident · Minor injuriesClosedBellanca 7KCAB · Wetumpka, ALNTSB MIA78FKQ05Accident · No injuriesClosedN.American P-51 · Ellisville, MSNTSB MIA78FLD21Accident · 1 fatalClosedHolt PDQ2 · Arcadia, FLNTSB IAD78IA036Incident · No injuriesClosedBeech TC45J · Norfolk, VANTSB IAD78DKM05Accident · No injuriesClosedBeech B23 · Sophia, NCNTSB MKC78DCG10Accident · No injuriesClosedTerrill SPEC-L · Kimberling, MONTSB FTW78DPG06Accident · No injuriesClosedMustang II · Wheatley, ARNTSB OAK78DVG02Accident · No injuriesClosedMooney M-20B · Georgetown, CANTSB OAK77DVG66Accident · Minor injuriesClosedHome Built KR1 · Redding, CANTSB IAD77FIA23Accident · Serious injuriesClosedChampion 7ACA · Brandywine, MDNTSB CHI77DEE55Accident · No injuriesClosedBrantly 305 · Wheeling, ILNTSB SEA77DYP40Accident · No injuriesClosedGrumman G-164B · Quincy, WANTSB MKC77DER74Accident · No injuriesClosedPietenpol-A Scout · Mankato, MNNTSB CHI77FA062Accident · 1 fatalClosedBellanca 7ACA · Oshkosh, WINTSB SEA77DYA27Accident · No injuriesClosedHughes 269C · Gooding, IDNTSB MIA77DLG20Accident · No injuriesClosedBell 47D · Oswego, SCNTSB LAX77FUG43Accident · No injuriesClosedScorpion TOO · Corona, CANTSB CHI77FEM25Accident · No injuriesClosedPiper PA36 · Grant, MINTSB SEA77FYK06Accident · No injuriesClosedStinson 108 · Burns, ORNTSB MKC77DCJ48Accident · No injuriesClosedSportavia RF4-D · Central City, NENTSB MIA77FLD50Accident · Minor injuriesClosedSikorsky H19E · Lady Lake, FLNTSB OAK77DXQ16Accident · No injuriesClosedSchneider ES-60 · Fernley, NVNTSB DEN77FTE25Accident · No injuriesClosedPiper PA-24 · Eckley, CONTSB OAK77FA019Accident · 1 fatalClosedBoeing B75N1 · Jean, NVNTSB MIA77FLD17Accident · No injuriesClosedBirdman TL-1 · Deland, FLNTSB FTW77DRA01Accident · No injuriesClosedDemoiselle A · Columbus, TXNTSB NYC77FFA01Accident · No injuriesClosedBell 47G-2 · Utica, NYNTSB CHI77FEM01Accident · No injuriesClosedJeanies Teenie · Frankfort, MINTSB DEN76DQD34Accident · Minor injuriesClosedCessna 188A · Hatch, NMNTSB FTW76DRG85Accident · Minor injuriesClosedBucker BU-133 · Cibolo, TXNTSB MKC76FCA39Accident · No injuriesClosedBell 47J · St Louis, MONTSB MKC76FCJ56Accident · No injuriesClosedPiper PA-36 · Imperial, NENTSB CHI76FEE69Accident · No injuriesClosedSportster HA-2M · Rockford, ILNTSB FTW76DPD51Accident · No injuriesClosedPiper PA-36 · Gilliland, TXNTSB SEA76DYA39Accident · No injuriesClosedHughes 269A · Gooding, IDNTSB LAX76DUG63Accident · Serious injuriesClosedWestfall Sport · Murrietta, CANTSB FTW76FQG81Accident · Serious injuriesClosedPiper PA-36 · Earth, TXNTSB OAK76FVD40Accident · Serious injuriesClosedHutchinson EH-1 · Stockton, CANTSB OAK76DVW26Accident · No injuriesClosedBeech V35 · Furnace Creek, CANTSB OAK76FXQ39Accident · No injuriesClosedBede BD-5 · Reno, NVNTSB LAX76FUA22Accident · 1 fatalClosedBirdman TL-1 · Anaheim, CANTSB LAX76DVG40Accident · Minor injuriesClosedScorpion TWO · Corona, CANTSB LAX76DUM23Accident · No injuriesClosedScorpion TOO · San Diego, CANTSB MIA76AM065Accident · No injuriesClosedCessna 172 · Ormond Beach, FLNTSB OAK76FJA08Accident · No injuriesClosedMurrayair MA-1 · Hilo, HINTSB DEN76FQA22Accident · Minor injuriesClosedBernardin MS-2 · Albuquerque, NMNTSB FTW76AF023Accident · Serious injuriesClosedDouglas DC-8 · Texico Vortac, TXNTSB SEA76FYE13Accident · No injuriesClosedDehavilland DHC-3 · Auburn, WANTSB LAX7LDUQ07|LAX76DUQ07Accident · No injuriesClosedPitts Spcl S1C · Lompoc, CANTSB CHI76DEC05Accident · No injuriesClosedDehavilland DH-82A · Otisville, MI
Back to Amateur-built UNKNOWN ENG