Cessna 172A
NTSB investigations · 248
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.aircraft_model_code IN ('2072404')
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 ('2072404')
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 ATL88LA038Accident · No injuriesLimited investigationFinal reportCessna 172A · Dayton, OHThe plt rptd that the engine began to sputter and lose power shortly after takeoff. A forced ldg was subsequently made in a nearby river. The acft nosed over on ldg and came to rest partially submerged in about 4 feet of water. Post-crash exam of the airplane…NTSB ATL87FA235Accident · 1 fatalField investigationFinal reportCessna 172A · Camilia, GAThis flt had been delayed several days due to poor weather in the area. On the day of the flt the plt waited until the local area fog had dissipated before departing the private air strip. The acft was heard above the clouds about five miles from the crash…NTSB DEN87LA205Accident · No injuriesLimited investigationFinal reportCessna 172C · Cut Bank, MTThe plt stated that she radioed the Cut Bank fss and was told that the wind was 060 degrees at 41 knots. She then landed the acft uneventfully. However, while turning 90 degrees off the rwy onto a taxiway, the acft nosed over.NTSB NYC87LA037Accident · No injuriesLimited investigationFinal reportCessna 172 · Montgomery, NYWhile taxiing in the middle of the taxiway the propeller of N58380 contacted the wing of N7416T. N58380 then rotated and it's wing contacted the wing of N7416T. N7416T was stopped alongside the taxiway when the accident occurred.NTSB SEA86LA221Accident · Minor injuriesLimited investigationFinal reportCessna 172A · San Juan Island, WAThe pilot was flying the aircraft at a low altitude in order to spot fish. He ran the right fuel tank dry causing the engine to quit. He was unable to switch fuel tanks and attempt a restart due to his low altitude. A forced landing was made close to the…NTSB FTW86LA155Accident · No injuriesLimited investigationFinal reportCessna 172A · Gainesville, TXThe pilot was taxiing into position for takeoff, when there was a wind shift and a gust of wind inverted the aircraft. The pilot had not obtained any weather reports prior to taxiing out to the runway. There were thunderstorms in the area and a heavy rain…NTSB LAX86LA230Accident · No injuriesLimited investigationFinal reportCessna 172B · Tracy, CAThe acft veered off a rural dirt road being used as an airstrip and nosed over in a farm field. The plt indicated that he was attempting to land on a narrow dirt farm road when the acft veered into a freshly plowed and irrigated tomato field. The nose gear…NTSB DEN86LA053Accident · No injuriesLimited investigationFinal reportCessna 172A · Anthony, NMThe plt was practicing emer ldgs on a dirt road. During the last ldg which resulted in an accident, he allowed his attention to be diverted momentarily to inside the cockpit and he lost control of the acft. The acft veered off the roadand sustained…NTSB ATL85FA237Accident · 1 fatalField investigationFinal reportCessna 172A · Glencoe, KYThe acft crashed in a field next to where a friend of the plt was baling hay. The plt had called the friend earlier in the day & ask the friend to go fly with him. Just prior to the acdnt, the plt flew over & circled a couple of times at low alt. Two…NTSB FTW85FA060Accident · 1 fatalField investigationFinal reportCessna 172A · Hammond, LANon-stop endurance for this make/model is 4.2 hrs in normal cruise. Calculated ete for plt's reported route of flight is 4.0 hrs (non-stop, no wind, normal cruise). Time from intial departure to mishap was 6.0 hrs. Acft of this discription was observed to…NTSB LAX84LA203Accident · Minor injuriesLimited investigationFinal reportCessna 172A · San Jose, CAThe plt of the Cessna 172 requested clearance to rwy 30R & was cleared as requested. While taxiing, he was cautioned about turbulence behind a DC-9. The DC-9 plts were waiting to takeoff on rwy 30L. The Cessna plt started to pass as the DC-9 was cleared onto…NTSB MKC84LA047Accident · No injuriesLimited investigationFinal reportCessna 172A · Hospers, IAThe plt said he was on a power line patrol flt & was flying aprx 60 to 80 ft AGL. Reportedly, he applied carburetor heat for about 1 min. When the carburetor heat was turned off, the eng quit. The plt reapplied the heat & the eng restarted for a moment & then…NTSB LAX83LA284Accident · No injuriesLimited investigationFinal reportCessna 172A · Carmel Valley, CAAccording to the pilot there were no tiedowns, chocks or other restraining devices available so he ask a non certificated person to sit in the aircraft and apply the brakes while he rotated the prop by hand to start the engine. The engine started and the…NTSB ATL83LA164Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Clinton, MDWitnesses observed that the acft took off from rwy 31, began a left turn, then descend into the trees. One witness, a lineboy, stated that he heard the engine running until the acft contacted the trees. The plt received a head injury and was unable to recall…NTSB DEN83FA039Accident · 1 fatalField investigationFinal reportCessna 172A · Leadville, COWhen a witness arrived at the arpt, the acft was at the fuel pumps & the plt had the preheater attached. The witness rprtd there was frost on the acft & the plt brushed the loose frost off with his hands. The plt asked for a window scraper, which was…NTSB SEA83FA029Accident · Serious injuriesField investigationFinal reportCessna 172A · Renton, WAThe eng lost power during takeoff at about 200 ft AGL. The acft then executed a left descending 180 deg turn & crashed on the flightline of an acft company. Investigation revealed that the fuel filter bowl contained about 1/2 fuel & 1/2 water, and the…NTSB CHI82DA151Accident · No injuriesFinal reportCessna 172A · Cissno Park, ILDuring takeoff on runway 09, the aircraft veered to the left. The pilot closed the throttle, but was unable to stop before the left wheel went into soft soil on the north side of the runway. Gusty winds from the south picked up the tail and gently rolled the…NTSB CHI81DEE47Accident · No injuriesClosedCessna 172A · Romeoville, ILNTSB FTW81FA090Accident · 1 fatalClosedCessna 172A · Verda, LANTSB LAX81FA082Accident · 2 fatalClosedCessna 172A · Silver Peak, NVNTSB ATL81DKM08Accident · Minor injuriesClosedCessna 172A · Maiden, NCNTSB LAX81FVG06Accident · Minor injuriesClosedCessna 172A · San Andreas, CANTSB ATL81FA006Accident · 4 fatalClosedCessna 172 · Roanoke, VANTSB ATL80DKG25Accident · No injuriesClosedCessna 172A · Athens, GANTSB CHI80FEM40Accident · No injuriesClosedCessna 172 · Fennville, MINTSB LAX80FXQ28Accident · 2 fatalClosedCessna 172A · Tahoe City, CANTSB CHI80FEC56|CHI79FEC56Accident · No injuriesClosedCessna 172 · Pontiac, MINTSB LAX79DUK15Accident · No injuriesClosedCessna 172 · Payson, AZNTSB NYC79FH214Accident · No injuriesClosedCessna 172H · Mt Kisco, NYNTSB MKC79FCJ20Accident · Serious injuriesClosedCessna 172A · Anselmo, NENTSB IAD79FA048Accident · 2 fatalClosedCessna 172A · Albany, KYNTSB NYC79FNA12Accident · No injuriesClosedCessna 172 · Boston, MANTSB DEN79FA012Accident · 1 fatalClosedCessna 172A · Park Valley, UTNTSB IAD78FIG11Accident · Minor injuriesClosedCessna 172 · Martinsburg, WVNTSB CHI78FEV33Accident · No injuriesClosedCessna 172A · Chrisman, ILNTSB FTW78FPD17Accident · No injuriesClosedCessna 172A · Brownwood, TXNTSB SEA78DYK13Accident · No injuriesClosedCessna 172 · Malin, ORNTSB MKC78DCQ17Accident · No injuriesClosedCessna 172A · Syracuse, KSNTSB CHI78FEK02Accident · No injuriesClosedCessna 172 · Quincy, OHNTSB NYC77FGM43Accident · Minor injuriesClosedCessna 172 · Somerset, PANTSB MKC77FER78Accident · No injuriesClosedCessna 172 · Ostrander, MNNTSB MKC77FER33Accident · Serious injuriesClosedCessna 172 · Terrace, MNNTSB MIA76DKJ67Accident · No injuriesClosedCessna 172A · Bessemer, ALNTSB MIA76AM088Accident · 1 fatalClosedCessna 172A · Milledgeville, GANTSB MKC76DER62Accident · No injuriesClosedCessna 172A · Hadley, MNNTSB OAK76FP050Accident · 2 fatalClosedCessna 172A · Planada, CANTSB DEN76DTM16Accident · No injuriesClosedCessna 172A · Logan, UTNTSB CHI76FEP19Accident · Serious injuriesClosedCessna 172A · Madison, WINTSB LAX7LDVA05Accident · Minor injuriesClosedCessna 172A · Bakersfield, CANTSB FTW76DQG06Accident · No injuriesClosedCessna 172A · Rotan, TX
Back to Cessna 172A