Skip to content

NTSB investigations · 138

Matched to the registry by N-number and event date, newest first.

Query with SQL

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 ('1850120') ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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 ('1850120')
  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 ('1850120')
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

Run 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 CHI92DCJ04Accident · No injuriesFinal reportCallair A-9 · Beaver City, NEThe inadequate maintenance overhaul of the left magneto, and subsequent failure of the left magneto/ignition system which caused a complete loss of engine power.Jul 10, 1992 · N9627Z · Substantial damage NTSB MKC90LA135Accident · No injuriesLimited investigationFinal reportCallair A-9 · Barrett, MNInadequate visual outlook and a delayed pull-up by the pilot in command.Jun 22, 1990 · N9621Z · Substantial damage NTSB DEN89LA181Accident · No injuriesLimited investigationFinal reportCallair A-9 · Cartwright, NDA total loss of power due to an improperly adjusted carburetor which resulted in an excessive rich fuel-air mixture. This required a forced landing in an area where no suitable terrain existed.Jul 28, 1989 · N8246H · Substantial damage NTSB CHI85LA363Accident · No injuriesLimited investigationFinal reportCallair A-9 · Hollandale, MNDuring a maneuvering turn while crop dusting the pilot experienced a muffler failure and engine fire. He landed successfully and abandoned the aircraft. Subsequent investigation revealed that the bracket that holds the muffler/ exhaust pipe to the aircraft…Aug 30, 1985 · N8273H · Substantial damage NTSB DEN85LA154Accident · Minor injuriesLimited investigationFinal reportCallair A-9 · Riverton, WYDuring an aerial application turn-around maneuver, the eng lost power. The plt stated that he immediately changed the fuel selector & turned on the boost pump, but the acft was too low for the eng to have time to restore power. The eng had been using fuel…Jun 7, 1985 · N8280H · Substantial damage NTSB MKC84FCD02Accident · Serious injuriesFinal reportCallair A-9 · Oakland, IAThe pilot was practicing aerial application maneuvers using water as the spray load. He stated that about half way thru his turn to reverse direction, he felt the a/c give a very slight stall warning. He said that he released some back pressure and attempted…Jul 22, 1984 · N8287H · Destroyed NTSB SEA80DTA11Accident · No injuriesClosedCallair A-9 · Bloomfield, MTApr 24, 1980 · N8246H · Substantial damage NTSB IAD80DKW13Accident · Serious injuriesClosedCallair A9 · Centerville, TNApr 21, 1980 · N8251H · Destroyed NTSB IAD80DKW02Accident · No injuriesClosedCallair A-9 · Greeneville, TNNov 6, 1979 · N8267H · Substantial damage NTSB MIA79FLG32Accident · No injuriesClosedCallair A-9 · Johnsonville, SCSep 11, 1979 · N3582G · Destroyed NTSB SEA79FYA21Accident · Minor injuriesClosedCallair A-9 · Hammett, IDJul 24, 1979 · N8286H · Destroyed NTSB MKC79DCJ28Accident · No injuriesClosedCallair A-9 · Kimball, NEJul 12, 1979 · N8294H · Substantial damage NTSB SEA79FYP15Accident · 1 fatalClosedCallair A-9 · Dayton, WAApr 29, 1979 · N8259H · Destroyed NTSB IAD78DLJ22Accident · Minor injuriesClosedCallair A-9 · Stella, NCAug 28, 1978 · N8266H · Substantial damage NTSB IAD77DLQ20Accident · Minor injuriesClosedCallair A9 · Sturgis, KYAug 22, 1977 · N9666Z · Substantial damage NTSB SEA77DYM30Accident · No injuriesClosedCallair A9 · Pilot Rock, ORApr 21, 1977 · N8267H · Substantial damage NTSB FTW76DRJ36Accident · No injuriesClosedCallair A-9 · Plain Dealing, LAJul 31, 1976 · N8292H · Substantial damage NTSB MKC76FCJ48Accident · No injuriesClosedCallair A-9 · Stromsburg, NEJul 13, 1976 · N7209V · Substantial damage NTSB SEA76FYA35Accident · 1 fatalClosedAero Comdr A-9 · Nampa, IDJul 7, 1976 · N8400V · Destroyed NTSB SEA76DTI29Accident · No injuriesClosedCallair A-9 · Pendroy, MTJul 6, 1976 · N9667Z · Substantial damage NTSB MKC76AK061Accident · 1 fatalClosedCallair A-9 · Larimore, NDJun 18, 1976 · N3588G · Destroyed NTSB CHI76FEM14Accident · No injuriesClosedCallair A-9 · Hart, MIJun 2, 1976 · N47061 · Substantial damage NTSB SEA76DYG46Accident · No injuriesClosedCallair A-9A · Wenatchee, WAApr 20, 1976 · N8259H · Substantial damage NTSB SEA76FYG38Accident · 1 fatalClosedCallair A-9 · Tekoa, WAMar 31, 1976 · N8281H · Destroyed NTSB SEA76FTI10Accident · Minor injuriesClosedCallair A-9 · Conrad, MTAug 26, 1975 · N8282H · Substantial damage NTSB IAD76FLJ05Accident · Serious injuriesClosedCallair A-9 · Kenansville, NCAug 9, 1975 · N7219V · Destroyed NTSB SEA75FTA10Accident · Serious injuriesClosedCallair A-9 · Glendive, MTOct 9, 1974 · N9650Z · Substantial damage NTSB MKC75FCA11Accident · 1 fatalClosedCallair A-9 · Charleston, MOOct 9, 1974 · N9661Z · Destroyed NTSB IAD75DLJ02Accident · No injuriesClosedCallair A-9 · Beaulahville, NCSep 6, 1974 · N8271H · Substantial damage NTSB FTW75FQG21Accident · No injuriesClosedCallair A-9 · Amarillo, TXSep 5, 1974 · N8284H · Destroyed NTSB SEA75FTA07Accident · No injuriesClosedCallair A-9 · Pryor, MTSep 3, 1974 · N3566G · Substantial damage NTSB MKC75FCD13Accident · No injuriesClosedCallair A-9 · Gilmore City, IAAug 26, 1974 · N3564G · Substantial damage NTSB MKC75FCJ21Accident · No injuriesClosedCallair A-9 · Brewster, NEAug 20, 1974 · N8257H · Destroyed NTSB IAD75FIJ03Accident · Serious injuriesClosedCallair A-9 · Rowland, NCAug 1, 1974 · N8236H · Destroyed NTSB LAX74FUJ72Accident · 1 fatalClosedCallair A-9 · Maricopa, AZJun 28, 1974 · N8256H · Destroyed NTSB FTW74DRA44Accident · No injuriesClosedCallair A-9 · Rosharon, TXJun 12, 1974 · N9663Z · Substantial damage NTSB FTW74DPA11Accident · No injuriesClosedCallair A-9 · Wilson, TXNov 16, 1973 · N3583G · Substantial damage NTSB FTW74FRJ18Accident · 1 fatalClosedCallair A-9 · Hooks, TXOct 26, 1973 · N3592G · Destroyed NTSB MIA74FLT02Accident · No injuriesClosedCallair A-9 · Coldwater, MSSep 5, 1973 · N9655Z · Substantial damage NTSB MKC74DER04Accident · Serious injuriesClosedCallair A-9A · Grygla, MNJul 31, 1973 · N8261H · Destroyed NTSB MIA73FKG85Accident · Serious injuriesClosedCallair A-9 · Mcrae, GAJun 24, 1973 · N3611G · Destroyed NTSB MKC73FCG44Accident · Minor injuriesClosedCallair A-9 · Phelps, MOMay 30, 1973 · N8288H · Destroyed NTSB LAX73DUQ36Accident · Minor injuriesClosedCallair A-9 · New Cuyama, CAMay 28, 1973 · N8262H · Substantial damage NTSB MKC73FTK08Accident · No injuriesClosedCallair A-9A · Murdo, SDOct 20, 1972 · N8288H · Substantial damage NTSB FTW74DPG24Accident · No injuriesClosedCallair A-9 · Rudy, ARSep 27, 1972 · N8237H · Substantial damage NTSB SEA73FYC07Accident · 1 fatalClosedCallair A-9 · Pendleton, ORAug 25, 1972 · N7201V · Destroyed NTSB SEA73DYA07Accident · No injuriesClosedCallair A-9 · Hamer, IDAug 18, 1972 · N9668Z · Substantial damage NTSB SEA72FYC49Accident · Serious injuriesClosedCallair A-9 · Harrisburg, ORJun 26, 1972 · N3588G · Substantial damage NTSB MIA72FKH05Accident · 1 fatalClosedAero Comdr A-9 · Leesburg, GAMay 20, 1972 · N8404V · Destroyed NTSB MKC72FCJ22Accident · Minor injuriesClosedCallair A-9 · Stromsburg, NEAug 30, 1971 · N7209V · Substantial damage

Back to Callair A-9