FAA incident reports
234,323 FAA reports of aviation accidents and incidents, from the FAA’s Accident/Incident Data System (AIDS) through its Aviation Safety Information Portal. An incident falls short of an accident: a bird strike, say, or a gear-up landing without substantial damage. The NTSB investigates accidents separately, and its record of an accident is the fuller one.
Reports, newest first
Query with SQL
duckdb -csv -c "SELECT report_number, event_date, event_type, city, state, aircraft_make, aircraft_model, aircraft_damage, fatal_injuries, n_number FROM 'https://openairdocs.org/data/latest/faa_incident_report.parquet' ORDER BY event_date DESC, report_number 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 report_number, event_date, event_type, city, state, aircraft_make, aircraft_model, aircraft_damage, fatal_injuries, n_number FROM 'https://openairdocs.org/data/latest/faa_incident_report.parquet' ORDER BY event_date DESC, report_number 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.
Incident 20120218004979IPerris, CAPerris Valley fatal parachute incidentAccident 20120218003809ABoeing 737-832 · Detroit, MIAircraft encountered mod. Turb. (Forecasted) on descent into the detriot mi. Area. Three pa's and two interphone announcements reguardung the turb were made prior to the turb. Area. The aircraft was slowed to the turb. Penetration speed. One pass. And one f/a…Incident 20120218003399IBrown R L Rans S-6ES Coyote II · Glendale, AZOn February 18, 2012 the aicraft was being operated during VMC conditions in cruise flight. Pilot reported fuel seeping into flight deck from fuel quantity gage. Seal on the sight gage failed. Pilot declared an emergency and landed safely without further…Incident 20120218002909IChampion 7ECA · Anchorage, AKPart of the tail wheel broke free from the aircraft on landing. Aircraft was conducting "touch and go" instruction. Pilot was radioed after a landing and takeoff and advised that part of the tail wheel was found on the runnway (25). The aircraft landed…Incident 20120218002759ICessna 207A · Kipnuk, AKFifteen minutes after arriving at Kipnuk Airport without event, the pilot in command, hauling four passengers and their baggage, failed to safely depart runway 15 resulting in damage to the aircraft; no reported injuries. Light to heavy snow had been falling…Incident 20120218002489IMooney M20E · Glendale, AZPilot stated she just forgot to put the landing gear down prior to landing.Incident 20120218002319IPiper PA-28-180 · Carver County, MNAircraft N5112L, a pa 28 cherokee 180, while en route to fcm form mml during a cross country solo, student pilot made an emergency landing in a field because #1 comm. Failed and fuel gauges were going down to empty due to possible electrical problems.…Accident 20120218002289ACessna 182A · New Philadelphi, OHA hard landing at Harry Clever Field (phd) on runway 14. Left wheel came off and the left wing hit the ground.Incident 20120218002239IPiper PA-20-150 · Belle Fourche, SDOn 02/18/2012 at approx. 12:00 noon a Piper- pacer, PA22-150, owned by [privacy data omitted], ground looped while practicing wheel landings. This incident happened while on landing rollout. VFR meteorological conditions prevailed, and no flight plan was…Accident 20120218002049ACessna 180 · South Fork, CO02/18/2012, @ 1441HRS MDT, N56180, Cessna (C-180), struck snow drift during landing on rwy 16 at South Fork, CO (CD69). Aircraft sustained substantial damage, no injuries to single occupant. VFR conditions prevailed.Accident 20120218002039ABeech C23 · Rawlings, WY02/18/2012, @0830MST, Beechcraft BE23, N5205M departed rwy 28 at rawliings, WY., attempted to return to airport and landed in field approx. 1 mile nw of airport. Aircraft sustained substantial dammage, 3 POB, no injuries. VMC conditions prevailed.Accident 20120217004929AMooney M20J · Weaverville, CAOn 02/17/2012 at 1306 PST an emergency landing on highway 299 and trinity dam blvd. Was reported by the highway patrol. The aircraft a Mooney-20-J, N367MR piloted by the [privacy data omitted] made this landing after experiencing total loss of engine power.…Accident 20120217002809ACessna 150J · Jasper, GAAircraft was in the pattern when engine started losing power, instructor took over, and when adding power, noticed engine quitting. Instructor located an emergency landing area, landed (over a powerline), hit a truck with his left wing, went over an…Incident 20120217002589ICessna 150F · Greenboro, GADuring the preflight of the aircraft the pilot did not correctly ascertain the actual fuel quantity in the aircraft using a visual means other then looking at the electric fuel gages installed in the aircraft. In the written statement and during the interview…Incident 20120217002429IZivko Aeronautics Edge 540 · Crows Landing, CAWhile enroute from 0Q4 to sql at appox 4500 MSL (operating under VFR rules, under VMC conditions) and just passing the 3O1 airport, the pilot noted engine oil streaking on the lower fuselage observation window. Within minutes, the engine oil streaking became…Accident 20120217002229ABeech 95-B55 (T42A) · Lancaster, WIOn February 17, 2012 at 1320 CDT , the pilot of a Beechcraft 95-B55 baron landed .5 miles north of runway 18, Lancaster Municipal Airport Lancaster wisiconsin due to fuel exhaustion. The pleasure flight was conducted in visual meterologocal condition and a…Incident 20120217002189IYoder Julius M JR Challenger CW II · Smyrna, SCWhile practicing emergency descents, the aircraft lost engine power near the town of Smyrna, SC. During the subsequent approach to an emergency landing on SC hwy 97, the aircraft's left wing struck a power line causing the aircraft to momentarily stall.…Accident 20120217002009AMooney M20TN · Fayetteville, NCOn February 12, 2012 at approximately 17:30 EST aircraft N118RZ, piloted by [privacy data omitted], was involved in an accident at Fayetteville, NC regional airport. Aircraft departed rdu for fay on February 17, 2012. Flight was normal until the landing at…Accident 20120217001999APiper PA-32R-300 · Swainsboro, GAOn February 18, 2012, this office was notified by the regional operations center (roc) at 11:30 am local time about an event involving a Piper PA-32-300 aircraft N47863 at Swainsboro, GA. (Ksbo). This inspector was conferenced with the airport manager, robert…Accident 20120217001819ACessna 172N · Powhatan, VAWhile cruising at 4,500 feet, PIC lost RPM from 2500 to 1500 RPM with a strong vibration. Pilot located a field, accomplished an emergency landing checklist and landed the aircraft. The aircraft hit a road embankment and telephone pole causing landing gear…Accident 20120216002539AEmbraer EMB-120FC · Iliamna, AKOn February 16, 2012, everts flight 1291, an EMB-120, N1110J, on an IFR flight plan from anchorage, AK (anc) (panc) to Iliamna, AK (ili) (pail), experienced uncommanded inflight pitch control excursions. The flight was a part 121 supplemental, cargo only…Incident 20120216001679ICessna 402B · Fort Lauderdale, FLOn February 16, 2012, at about 1330 local time, [privacy data omitted] (PIC) was flying aircraft N402GZ, a Cessna 402B on a local flight. After landing at Fort Lauderdale/Hollywood International Airport (kfll) on runway 9R, and exiting runway to the taxiway…Incident 20120215009829ILearjet 45 · Longview, TXDuring cruise at FL240 crew received #2 eng fire warning. Followed checklist items to include fire bottle and inflight shutdown, warning light did not extinguish. Declared emergency and diverted to kggg. Landed no incident. Crew confirmed no evidence of fire.…Incident 20120215005259IAmerican Champion 7ECA · Livermore, CADuring touch down on runway 25R aircraft mains were down and tail wheel was still up. Pilot experienced a right hand crosswind gust. Pilot lost control of aircraft and veered off the left side of runway over gravel & grass clipping and damaging a single…Incident 20120215003309IDehavilland DHC-6 Twin Otter · Eloy, AZSkydiver (ke dime) exited the jump bird at approximately 5000 ft AGL for the purposes of practicing a "swooping" landing. (Swooping is a maneuver in which the skydiver operates his canopy so as to accelerate his vertical descent speed prior to landing. This…Accident 20120215003099ACessna 172S · Northbend, WACause of accident unknown. It appears from looking at the radar track data provided by ATC of N665SP and looking at a terminal area chart that the aircraft departed renton airport from runway 16, made a left downwind departure, climing over the newcastle area…Accident 20120215002739ABell Helicopter Textron Canada 407 · Jackson, WY02/15/2012, @1405MST, Bell helicopter, B407, N407HL, was destroyed during a hard landing in trees NE of Jackson, WY. 3 POB, 1 fatal, 2 serious. VMC conditions prevailed.Accident 20120215002611ABeech 58 · South Charlesto, WVAircraft departed charleston WV approx 1115, per the pilots statement, the flight had been uneventful prior to landing at the private airstrip WV12 approx 1130. During touchdown the pilot lost control of the aircraft (unknown reason). The aircraft departed…Incident 20120214003889ICessna A185F · Miami, FLPilot states that after landing at the Tamiami airport (tmb), he was taxiing on taxiway h heading toward the general aviation ramp. He made a left turn to exit on intersection H4 but overshot the intersection and went into the grass and hit a taxiway sign.…Accident 20120214002979APiper PA-32-260 · Amory, MS02/14/2012- FSDO received notification approximately 0800 hrs regarding a possible downed aircraft south of tupelo. Approximately 1230 hrs the aircraft was located by local search and rescue teams in a heavily wooded area approximately 7 miles north of Amory,…Accident 20120214002409ABeech BE-18 · Hollister, CAOn February 14, 2012, at approximately 1340 pacific standard time, a Beech G-18S, australian registration vhnwb departed runway 31 at Hollister airport (kcvh). In a statement from the pilot, at approximately 30 to 40 feet after takeoff, the right wing dropped…Accident 20120214002179APiper PA-28-180 · Osborn, MOPilot and passenger were conducting a fly-by at a farm owned by friends of the passenger. After completing one circuit around the house at low altitude, the pilot came back around again at low altitude and struck a large tree with the right wing of the…Incident 20120214002159IPiper PA-44-180 · Coatsville, PAOn 02/14/2012 a Piper seminole (PA-44-180), registration number N2085B made a landing on runway 29 without the gear extended (gear up landing) at Chester County Airport in coatesville, PA (kmqs). The instructor that was involved had already left, but did…Incident 20120214002029IRockwell International S-2R · Yellow Pine, IDThe pilot touched down normally and was lined up with the center line of the runway. The pilot put the engine in reverse to slow the aircraft down, the additional torque caused the nose of the aircraft to veer to the right approximately five degrees. The…Incident 20120214001799IBeech 58P · Rogersville, TNThe aircraft departed ktys ( tri-cities regional airport) at 10:20, under IFR conditions, to krvn (Hawkin County Airport) at 2500 AGL. He made his final approach under visual conditions, touching down at the 1000 ft. mark on a 3500 ft runway. A rain storm had…Incident 20120213005249IPiper PA-28R-200 · Milton, FLDuring 2.5 hour training flight aircraft made two sucessfull landing at kbfm and kpns prior to incident. During final to 2R4 landing gear indicated unsafe. Visual confirmation by ground personnel and flight crew confirmed nose gear was at mid extension.…Accident 20120213003109AZenair CH 2000 · Midland, VAThe aircraft began the takeoff ground roll on runway 33. Upon rotation the instructor simulated a powerplant failure by retarding the throttle to idle. The aircraft descended back to the runway and the student added full power. Aircraft control was lost and…Incident 20120213002969IBombardier CL-600-2B19 · Greer, SC13 Feb 2012 about 0630 at the greenville spartenburg airport. Pilot attempted to start the APU. It would not start. 1st officer returned from the walk around inspection and informed the pilot he could hear a slow ignitor firing. 1st officer attempted to start…Incident 20120213002569IGates Learjet 55 · Brooksville, FLOn February 13, 2012, at 2200 hours local time, a lear 55, N75LJ, registered to jkb jet holdings LLC, ran off the runway to the left when departing runway 27, at Hernando County Airport (bkv) while on a repositioning flight to william p. hobby airport (hou).…Accident 20120213002559ACessna 172S · Eufala, ALDuring a night landing touchdown at keuf February 13, 2012 at 1905 CT a Cessna 172S aircraft operated by auburn university (DW8S) sustained an inflight impact with a deer crossing the runway. Airplane sustained substantial damage to the nose, main landing…Incident 20120213002459ILearjet LR-35A · Jefferson City, MOThe aircraft was on a flight from flying cloud airport, minneapolis, MN (fcm), to Jefferson City memorial airport, Jefferson City, MO (jef). Upon landing at jef on rwy 30, the pilot stated that both thrust reversers were commanded to deploy. He noted that the…Accident 20120213001969ARobinson Helicopter R44 · Charleston, SCThe pilot in command (PIC) , a certificated flight instructor, and a student pilot, were performing an auto rotation to ground. The PIC statement indicated that the helicopter was decending fast, and that he took control of the helicopter. He did not add…Incident 20120213001569ICessna 650 · Lincoln, NEAs the aircraft was taxiing for departure from the ramp, the nose wheel and the left main wheel left the pavement onto the snow-covered turf.Incident 20120213001509IGates Learjet 55 · Minneapolis, MNPart 91 reposition flight from msp to rst. Pilot aborted takeoff at approximately 70-80 knots due to heavy vibration. Pilot applied light braking and vibration got worse. At approximately 30 knots aircraft pulled hard to left and aircraft exited runway to the…Incident 20120213001319IPiper PA-31T · Mount Pleasant, MIAircraft struck deer with right propeller/engine during first 2000' of takeoff from runway 27, at approximately 80 knots. Takeoff was aborted and aircraft taxied off the runway to parking area.Incident 20120212001809IPiper PA-32R-301T · San Angelo, TXOn February 12, 2012, N52MD departed elgin field, (kefd) just outside of houston, enroute to ruidoso, (ksrr) new Mexico. The pilot stated he began to encounter an icing condition and devirated to San Angelo (ksjt). He received IFR clearance for runway 03…Accident 20120212001729APiper PA-18-135 · Glacier, WAThe pilot was in the process of droping emergency supplies to some injured and stranded snowmobilers at about the 8300 ft. level on Mt. Baker. After the drop he applied full power and banked slightly left heading away from terrain. He encountered what he…Incident 20120212001629IGreat Lakes 2T-1A-2 · Chandler, AZN6075L, with a CFI and student under part 91 and 61, were performing touch and go landings on runway 22R at Chandler municipal airport. On the rollout for the last scheduled landing they began to turn off the runway at taxiway kilo when the tail began to…Incident 20120212001519IPiper PA-31-310 · Ft. Lauderdale, FLDuring climb out of kfll aircraft experienced a decrease in manifold pressure of the left engine. Pilot unable to resolve and declared an emergency returned back to kfll. Engine was not shut down and aircraft landing without incident. No damage. No injuries.Incident 20120212001489IDowner Bellanca 14-19-3 · Brainerd, MN[privacy data omitted] Was landing on rwy 23 at brd on 2-12-2012 and forgot to lower landing gear. Pilot was practicing short feild landing and had extra power on final, could not hear gear horn. Aircraft landed gear up with no injuries and minimul damage.