Skip to content

NTSB investigations · 116

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 ('0191202') 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 ('0191202')
  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 ('0191202')
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 ERA25LA085Accident · Serious injuriesClass 4 · LimitedFinal reportAeronca 15AC · Loganville, GAThe pilot’s failure to maintain clearance of trees during an attempted go-around in sun glare.Dec 25, 2024 · N6665K · Substantial damage NTSB ANC21LA087Accident · Serious injuriesClass 4 · LimitedFinal reportAeronca 15AC · North Pole, AKThe pilot’s failure to ensure adequate obstacle clearance while maneuvering, which resulted in a collision with a tree and a loss of control.Sep 10, 2021 · N1441H · Substantial damage NTSB CEN21LA303Accident · No injuriesClass 3 · LimitedFinal reportAeronca 15AC · Hastings, MIA total loss of engine power for reasons that could not be determined based on the available information.Jun 30, 2021 · N1175H · Substantial damage NTSB ANC17FA035Accident · 1 fatalField investigationFinal reportAeronca 15AC · Big Lake, AKThe pilot's failure to maintain clearance from trees during low-altitude flight, which resulted in an in-flight collision and impact with terrain.Jul 15, 2017 · N1370H · Substantial damage NTSB CEN17LA070Accident · No injuriesLimited investigationFinal reportAeronca 15AC · Pontiac, MIThe improper installation of the left wheel brake torque plate by maintenance personnel, which resulted in the separation of the torque plate from the axle endplate and a loss of directional control during landing.Dec 23, 2016 · N1337H · Substantial damage NTSB ANC14LA038Accident · No injuriesLimited investigationFinal reportAeronca 15AC · Talkeetna, AKMaintenance personnel’s failure to perform required fuel system tests to ensure that the airplane met its original type certification basis after modifying the fuel system and the Federal Aviation Administration’s improper approval of the fuel tank…Jun 6, 2014 · N1301H · Substantial damage NTSB ANC13LA065Accident · No injuriesLimited investigationFinal reportAeronca 15AC · Talkeetna, AKThe pilot’s loss of airplane control during landing for reasons that could not be determined based on the available evidence.Jul 13, 2013 · N1374H · Substantial damage NTSB ANC09CA093Accident · No injuriesData collectionFinal reportAeronca 15AC · Kotzebue, AKThe pilot's delay in aborting the off-airport landing resulting in a hard landing.Sep 7, 2009 · N1187H · Substantial damage NTSB ANC09CA089Accident · No injuriesData collectionFinal reportAeronca 15AC · Palmer, AKThe pilot's selection of unsuitable terrain for landing, which resulted in a runway excursion, collision with terrain, and nose over.Aug 28, 2009 · N1301H · Substantial damage NTSB ANC08CA125Accident · No injuriesData collectionFinal reportAeronca 15AC · Fairbanks, AKThe pilot's selection of unsuitable terrain for landing, resulting in an on-ground collision with a tree stump.Sep 16, 2008 · N1170H · Substantial damage NTSB ANC08CA056Accident · No injuriesData collectionFinal reportAeronca 15AC · Anchorage, AKThe pilot's excessive use of brakes during the landing roll. A factor was an excessive taxispeed.Apr 24, 2008 · N1452H · Substantial damage NTSB ANC04CA089Accident · No injuriesData collectionFinal reportAeronca 15AC · Big lake, AKThe pilot's inadequate evaluation of the weather conditions and subsequent collision with high vegetation during the initial climb after takeoff, which resulted in a collision with the ground. Factors contributing to the accident were the presence of a…Aug 7, 2004 · N4433N · Substantial damage NTSB ANC02LA030Accident · No injuriesLimited investigationFinal reportAeronca 15AC · Sitka, AKA loss of engine power during cruise flight for an undertermined reason. A factor in the accident was rough/uneven beach terrain at the site of the forced landing.Apr 14, 2002 · N1272H · Substantial damage NTSB ANC00LA129Accident · No injuriesLimited investigationFinal reportAeronca 15AC · Anchorage, AKThe pilot's inadequate compensation for high, gusty wind conditions during water taxi. Factors associated with the accident are high and gusty wind conditions.Sep 21, 2000 · N1455H · Substantial damage NTSB FTW00LA229Accident · Minor injuriesLimited investigationFinal reportAeronca 15AC · Pettigrew, ARthe pilot's failure to maintain obstacle clearance during landing.Aug 14, 2000 · N1282H · Substantial damage NTSB ANC99LA060Accident · Serious injuriesLimited investigationFinal reportAeronca 15AC · Pedro Bay, AKA separation of the number 3 engine cylinder head assembly, and a burned through fuel line.May 8, 1999 · N1315H · Substantial damage NTSB ANC98LA081Accident · No injuriesLimited investigationFinal reportAeronca 15AC · Homer, AKThe loss of engine power due to fuel starvation, and an improper fuel selector valve. Factors in the accident were turbulent wind conditions, the improper replacement of the fuel selector valve by an airplane mechanic, and the failure of an FAA inspector to…Jun 12, 1998 · N1023H · Substantial damage NTSB ANC95LA142Accident · No injuriesLimited investigationFinal reportAeronca 15AC · Glennallen, AKThe pilot's selection of unsuitable terrain for takeoff. High vegetation and upsloping terrain were related factors.Aug 16, 1995 · N1484H · Substantial damage NTSB ANC95LA005Accident · No injuriesLimited investigationFinal reportAeronca Sedan AR-15 · Nikolai, AKThe pilot's continued flight into adverse weather. Factors to the accident were falling snow, an obstruction of the fuel system vents, restriction of the fuel flow and lack of a suitable landing area.Oct 21, 1994 · N1428H · Substantial damage NTSB CHI94LA201Accident · Serious injuriesLimited investigationFinal reportAeronca 15AC · Napoleon, MIa loss of engine power for unknown reasons. A factor related tot he accident were the trees encountered.Jun 17, 1994 · N5114Y · Substantial damage NTSB ANC92LA175Accident · No injuriesLimited investigationFinal reportAeronca 15AC · Ptarmigan Pass, AKThe partial failure of the normal brake system, the misjudging of the proper touchdown point and the attempted go around. Factor was the rough and uneven landing area.Sep 8, 1992 · N1009H · Substantial damage NTSB ANC92LA051Accident · Minor injuriesLimited investigationFinal reportAeronca 15AC · Port Alsworth, AKThe pilot inadvertently conducted VFR flight into IMC conditions. Contributing factors were low ceilings, snow, rain, icing conditions, and whiteout conditions.Mar 23, 1992 · N1469H · Substantial damage NTSB ANC91LA156Accident · No injuriesLimited investigationFinal reportAeronca Sedan 15AC · Anchorage, AKFailure of the pilot to ensure that the fuel caps were secure, which restuled in a fuel leak and subsequent fuel exhaustion.Oct 1, 1991 · N1416H · Substantial damage NTSB ANC91LA044Accident · No injuriesLimited investigationFinal reportAeronca 15AC · Kotzebue, AKFuel contamination (water) in both fuel tanks and fuel lines.Apr 1, 1991 · N1376H · Substantial damage NTSB CHI91LA102Accident · 1 fatalLimited investigationFinal reportAeronca 15AC · St.Croix Falls, WIFailure to conduct a passenger safety briefing, and inadequate supervision, by the pilot in command. A factor related to the accident is the passenger's inattentiveness.Mar 3, 1991 · N1340H · No damage NTSB CHI89DEP06Accident · Minor injuriesFinal reportAeronca 15AC · Fort Atkinson, WIWater contamination of the fuel and the pilot's inadequate preflight. Factors related to the accident were: lack of suitable terrain for a forced landing & trees.Jul 3, 1989 · N1271H · Substantial damage NTSB CHI89DEM02Accident · Minor injuriesFinal reportAeronca 15AC · Plainwell, MIThe pilot's decision to fly the airplane which had not been properly maintained which resulted in the fuel system blockage.Jun 6, 1989 · N1003H · Substantial damage NTSB ANC89LA053Accident · No injuriesLimited investigationFinal reportAeronca 15AC · Fairbanks, AKThe student pilot's inproper use of carburetor heat and the instructors failure to properly supervise the student actions within the airplane.Mar 16, 1989 · N4433N · Substantial damage NTSB CHI89LA017Accident · No injuriesLimited investigationFinal reportAeronca 15AC · Mora, MNOct 24, 1988 · N1162H · Destroyed NTSB CHI87LA189Accident · No injuriesLimited investigationFinal reportAeronca 15AC · St Bonifacius, MNThe plt had just purchased the acft & had obtained a ferry permit to fly it to another arpt. He reached the vicinity of the destn & called the tower, but did not see the arpt. Aprx 15 min later, when he was sure he had passed the arpt, he made a 180 deg turn…Aug 6, 1987 · N1135H · Substantial damage NTSB ANC87LA104Accident · No injuriesLimited investigationFinal reportAeronca 15AC · Charley River, AKThe pilot stated that during the takeoff roll he struck a hidden tree stump; he lost directional control of the aircraft causing the plane to nose over.Jul 22, 1987 · N1023H · Substantial damage NTSB CHI87LA105Accident · No injuriesLimited investigationFinal reportAeronca 15AC · Hibbing, MNThe plt stated that while taxiing on the north taxiway, for takeoff on runway 31, a 'gust of wind caught the tail abruptly and caused plane to veer to the left and strike corner of hangar.' The acft collided with the hangar nose first.Mar 28, 1987 · N1156H · Substantial damage NTSB ANC86LA068Accident · No injuriesLimited investigationFinal reportAeronca 15 AC Sedan · Neal Lake, AKAccording to the pilot-in-command, while step taxiing for takeoff the airplane became airborne inadvertently with insufficient room to takeoff or turn. The pilot-in--command stated he closed the throttle and the airplane touched down on the lake. He was…Jun 9, 1986 · N1450H · Substantial damage NTSB ANC84LA134Accident · No injuriesLimited investigationFinal reportAeronca 15AC · Murphy Dome, AKThe CFI said the engine quit in 'straight and level flight' & 'acted like fuel starvation.' The prop was windmilling. Restarts were attempted without success. A forced landing was made in a wooded area. The landing was cushioned by the acft floats and wings.…Aug 22, 1984 · N1067H · Substantial damage NTSB ANC84LA109Accident · Serious injuriesLimited investigationFinal reportAeronca 15AC · Ester, AKThe acft was landed in the tops of small spruce trees after the engine lost oil pressure and was shut down. The plt later admitted that the oil lines needed relacement on the last annual on 06-22-84 but he postponed it and later forgot to do it in the…Jul 1, 1984 · N1436H · Substantial damage NTSB CHI81DER66Accident · Minor injuriesClosedAeronca 15AC · Lake Crystal, MNSep 6, 1981 · N1331H · Substantial damage NTSB ANC81DAG59Accident · Minor injuriesClosedAeronca 15AC · Anchorage, AKAug 5, 1981 · N1484H · Substantial damage NTSB ANC81DAG57Accident · No injuriesClosedAeronca 15AC · Sterling, AKAug 2, 1981 · N1058H · Substantial damage NTSB ANC80FA045Accident · 1 fatalClosedAeronca 15AC · Wasilla, AKMay 16, 1980 · N1007H · Substantial damage NTSB ANC80FA038Accident · 1 fatalClosedAeronca 15AC · Skwentna, AKApr 2, 1980 · N1206H · Destroyed NTSB ANC80DAG45Accident · No injuriesClosedAeronca 15AC · Tonsina, AKMar 15, 1980 · N1209H · Substantial damage NTSB ANC79DAA29Accident · No injuriesClosedBellanca 15AC · Fairbanks, AKJul 31, 1979 · N1180H · Substantial damage NTSB ANC79DAG23Accident · No injuriesClosedAeronca 15AC · Iliamna, AKSep 13, 1978 · N1346H · Substantial damage NTSB MKC77PAG03Accident · No injuriesClosedAeronca 15AC · Anchorage, AKOct 2, 1977 · N1293H · Substantial damage NTSB NYC77FA003Accident · 1 fatalClosedAeronca 15AC · Erwinna, PAOct 14, 1976 · N1269H · Substantial damage NTSB MKC76DTK25Accident · No injuriesClosedAeronca 15AC · Union Center, SDMay 4, 1976 · N1240H · Substantial damage NTSB OAK76FVW13Accident · Serious injuriesClosedAeronca 15AC · Goldfield, NVMar 2, 1976 · N1345H · Substantial damage NTSB NYC7LFNA17Accident · No injuriesClosedAeronca 15AC · Wareham, MAOct 5, 1975 · N1365H · Substantial damage NTSB ANC76DAA10Accident · No injuriesClosedAeronca 15AC · Fairbanks, AKAug 22, 1975 · N1477H · Substantial damage NTSB SEA76FYI03Accident · No injuriesClosedAeronca 15AC · Lapine, ORJul 13, 1975 · N1313H · Substantial damage

Back to Aeronca 15AC