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 20040318005639IBeech 1900D · Tampa, FL(-23) On take off roll, crew noted a lack of proper acceleration. The crew verified both engines were producing adequate power and the parking brake was released. At approximately 80 knots, the decision to abort the takeoff was made due to continued poor…Accident 20040318005209ASwftms GC1B · Placerville, CA(-23) After taking off, pilot stated that the aircraft engine lost power. Pilot attempted to turn around and land on the runway. Aircraft crashed adjacent to the runway into some trees. Aircraft was destroyed, the pilot sustained minor injuries. Visual…Incident 20040318003909ICessna 414A · Midland, TX(-23) On March 18, 2004, N414FB, a Cessna model 414A aircraft, was departing Midland international airport (maf) enroute to lancaster, Texas, when the pilot noticed the fuel flow and hydraulics systems had become inoperative. The aircraft engine controls…Incident 20040318002669IAirbus A310203 · Louisville, KY(-23) Federal express - flt. 684, 03/18/02004 after level off at flight level 31000 feet out of rochester, new york on route to memphis, TN, the flight crew received an advisory message indication of an air conditioning system concern. Shortly thereafter an…Accident 20040317016909ARobsin R44 · Ocala, FL(-23) The true facts are unknown at this time. Interviews with several individuals close to the pilot do not agree with pilots account. Sometime between 1200 am and 0300AM the pilot crashed his helicopter on the taxiway at the Ocala airport. It is not known…Accident 20040317016639ACessna 150C · Deland, FL(-23) A non-pilot and passenger departed bob lee airport Deland FL in a Cessna 150 (N2080Z) at 1025 EST on 3-17-04, and at 1026EST witnesses reported hearing the engine sputter then saw the aircraft bank right then left and dove vertically into a fernery…Accident 20040317007319APiper PA28151 · Goldthwaite, TX(-23) Aircraft crashed approx. 300 feet short of intended landing strip due to loss of power and aircraft altitude too low to reach touchdown zone. Pilot had completed 2 hr. 10 min. Cross country flight from rockwall, TX to Goldthwaite, TX. He made a low pass…Incident 20040317006939IBoeing 727227 · Peoria, IL(-23) On a revenue flight from msn to pia the flight crew experienced a loss of oil quantity and pressure on number 1 engine about 20 minutes after departure, on descent into pia. The a/c was about 60 miles north of pia. The PIC completed the #1 engine…Incident 20040317004939IBeech 76 · Dothan, AL(-23) The pilot was demonstrating touch and go landings at Dothan airport, Dothan, Alabama (dhn) for a 141 standardization flight. While on the take off roll, the pilot raised the landing gear before the aircraft was airborne. The nose gear collapsed getting…Accident 20040317004429AAmtr Skybolt · Reno, NV(-23) The pilot reported that he was executing an outside loop maneuver. At the bottom of the loop, while inverted at approximately 8,000 feet MSL, the pilot felt a vibration followed by a separation of the left wing from the aircraft. The aircraft continued…Accident 20040317004119APiper PA18150 · Sisters, OR(-23) [privacy data omitted] departed corvallis, OR to prineville, OR. Enroute at 7500FT after crossing the cascade mountains [privacy data omitted] began a shallow descent (as described by [privacy data omitted]). [privacy data omitted] Stated that the…Incident 20040317003889IPiper PA23250 · North Platte, NE(-23) On March 17, 2004, at approximately 0745, the pilot in command of Piper PA-23-250, N32RW, sn: 27-4667, experienced a mechanical failure of the landing gear selector handle during approach to the North Platte, Nebraska municipal airport. The PIC reported…Incident 20040317003299ICndair CL6002B19 · Salt Lake City, UT(-23) Skywest flight 3924, struck an unknown number and type of birds on approach to slc. The aircraft landed without incident.Incident 20040316016619IAMD FALCON900 · Los Angeles, CA(-23) On 3/16/2004, N900MG, Dassault FA50 reported the NLG would not deploy and diverted to lax. Pilot executed nose gear up landing on runway 25R. N900MG skidded 1000' on it's nose after touch down. No injuries to the 15 passengers on board. Nose gear…Incident 20040316010899ICessna 172RG · Fort Worth, TX(-23) On March 16, 2004 at 1149 central time a Cessna, CE-172-RG, N9620B owned by ate of Texas inc. was operated by patrick o'neal who was giving flight instruction to francisco torrent when they were involved in an incident after making an emergency landing…Incident 20040316010799ISocata TB20TRINIDAD · Houston, TX(-23) On March 16, 2004, approximately 15:36 CDT, a aerospatiale TB20, N5547J, received minor damage when the PIC (instructor) Mr. Takashi shimiza made an gear up landing at Sugar Land airport (ksgr), Texas. The aircraft was registered to cielazur LLC,…Accident 20040316007209AWSK M18A · Safford, AZ(-23) Aircraft was doing water drops for the blm to test for use on wildfires. Aircraft spun in on a low pass.Incident 20040316006639IBeech C23 · Chicago/Wheelin, IL(-23) CFI stated that aircraft made a firm but not exceptionally hard landing at night upon touchdown. A bang was heard, followed by a 20 degree swerve to the left. CFI thought it was a blown tire, but soon discovered that he could not move aircraft and…Accident 20040316006569APiper PA30 · Galveston, TX(-23) On March 16, 2004, at approximately 13:52 CDT, a Piper PA-30-30, N572AS, received substantial damage when the (PIC) colin megless, lost control of the aircraft while landing on runway 31 at kgls. The aircraft skidded approximately 150', exited the…Accident 20040316006309AAmtr CHALLENGER2 · Labelle, FL(-23) On March 06, 2004, at about 0915 eastern standard time, an unregistered quad city aircraft corp. challenger ii aircraft, operated by a private individual as a title 14 CFR part 91 personal flight, crashed in Labelle, Florida. Visual meteorological…Incident 20040316004729IPiper PA28R200 · San Jose, CA(-23) The pilot called the tower to request a full stop landing at Reid Hillview airport. The tower replied asking the pilot to report 3 miles on base to 31R. Upon reaching 3 miles on base, the pilot tried to contact the tower and realized that com 1 was not…Incident 20040316003989IPiper PA28161 · Chandler, AZ(-23) Student pilot in a Piper PA-28 N8400A was on first supervised solo after completing first takeoff and landing; student taxied to runup area and pulled in behind a Piper arrow N55068. Upon receiving takeoff clearance the student pilot started to taxi and…Incident 20040316003939IPiper PA28R200 · Chandler, AZ(-23) Student pilot in a Piper PA-28 N8400A was on first supervised solo after completing first takeoff and landing; student taxied to runup area and pulled in behind a Piper arrow N55068. Upon receiving takeoff clearance the student pilot started to taxi and…Accident 20040316003599AMooney M20K · Mar Vista, CA(-23) On 3/16/2004 Mooney M-20-K impacted a house on final approach to sant monica airports, santa monica CA. Weather reported at time of accident was 1/2 mile visibility with fog and 200 feet overcast. Accident still under investigation by this office.Accident 20040315016969ACessna 182P · Springhill, FL(-23) On March 15, 2004, at 2005 hours local time, a Cessna 182, N8148G, registered to nora flight services, collided with the ground at Springhill, Florida. At the approximate time of departure, visual meteorological weather prevailed, however at the time of…Incident 20040315010879IBell 206B · Venice, LA(-23) A precautionary landing was performed after encountering reduced visibility due to fog. Obscuration of the windscreen compounded by the improper use of the defogging system while on the approach to landing phase of operations caused the main rotor…Incident 20040315008589IAmtr KR2 · San Jose, CA(-23) After an uneventful landing, pilot rolled out to the end of runway 31R, turned premature of the runway into a taxiway sign.Accident 20040315006409ABeech A36 · Conroe, TX(-23) Aircraft was fueled with 53 gallons of aviation kerosene (jet-a) and lost power in IMC then landed in a small pasture.Accident 20040315004079ACessna 182P · Monticello, UT(-23) While attempting to land airplane hit ground short of runway. Block 18;20;29;31;32;42;43 are incomplete and an amended report will be filed. (-23 amendment) pilot and his passenger (son) landed at an unimproved dirt strip in southern Utah for…Accident 20040315003719ABeech 1900D · Manhattan, KS(-23) While acting as the pilot-in-command of air midwest flight 5208 on March 15, 2004, captain robert peterson holder of ATP certificate 529023720, failed to maintain positive control of N155ZV after landing at Manhattan, Kansas (mhk). The winds were…Incident 20040315002559IPiper PA31350 · Kansas City, MO(-23) Pilot stated he was level at 5000 feet when he observed the right engine RPM dropping to 1000 RPM. He elected to shut down and feather the right engine. He asked center for landing at the closest airport. He was diverted and landed at mci using the left…Incident 20040314014849IWest Palm Beach, FL(-23) Passenger was verbally abusive to crew when told to turn off cell phone prior and during taxi. Injury summary not known by ASI.Accident 20040314005469ACessna 172C · Thermal, CA(-23) On March 14, 2004 the pilot in command of N8287X commenced a flight from desert center airport, desert center, CA (L64) to his privately owned landing strip at [privacy data omitted] the flight was terminated with loss of control during the landing…Accident 20040314004579ACcoptr TOMCATMK5A(-23) After spraying an alfalfa field, pilot was feerying the helicopter to another alfalfa field within one half mile. Enroute at 100 fleet above the ground, aircraft shook violently for approx. two to three seconds then engine quit. Pilot performed…Accident 20040314004059ACessna 172M · Eltopia, WA(-23) Pilot departed kennewick airport and approximately 15 miles north of pasco had engine RPM drop from cruise of 2400 to 1800 and start running rough. Pilot pulled on carburetor heat and apparently added throttle, and checked fuel system including primer.…Accident 20040314003269ACessna 172L · Turner, ME(-23) On the 3rd leg of a solo x-country, student pilot, lawreston crute, was on a final for runway 30 at Twitchell's airport, Turner, ME. The student pilot was high for the approach and elected to make a go-around. On his 2nd attempt the student pilot…Incident 20040314003229IConaer LA4200 · Cusick, WA(-23) On March 14, 2004 Dr. James cool was acting as pilot in command of N65675, a lake amphibious airplane on the pend oreille river near Cusick, Washington. Dr. Cool stated he had been practicing "touch and goes" on the river when he damaged the aircraft.…Incident 20040314003029ICessna 310P · Long Beach, CA(-23) Pilot was unable to extend all three gear. Investigated all options, decided to land with left main still retracted. Push-pull rod brace appeared to have broken, enabling motor to run full limit without effecting associated gear. See attached pilot…Incident 20040314003019IPiper PA28140 · Savannah, GA(-23) Pilot was landing on runway 09 at Savannah International Airport (sav), when a gust of wing caused the aircraft to drift off the runway. The winds reported at the time by sav ATCT were 130 to 140 degrees at 10 knots gusting to 15 knots. The pilot stated…Incident 20040313020059ICessna 337A · Grundy, VA(-23) [privacy data omitted] Mr. Keith r. latham was pilot in command and conducting an after maintenance test flight at Grundy, VA, where the aircraft had recently had maintenance. The mechanic/ia who performed the maintenance was a passenger on this flight.…Accident 20040313010959AAirtrc AT301 · Dealing, LA(-23) During take off the aircraft lost power for a moment and then started to regain power. The aircraft's altitude was insufficient to compensate for the loss of power. The aircraft's wings struck two trees and both the MLG struck a creek bank causing them…Accident 20040313007849ABeech 65A90 · Ft Lauderdale, FL(-23) On March 13, 2004 at approximately 0450 eastern standard time aircraft N11FL, a Beechcraft BE-65-A90, serial number LJ-301, operated by execstar aviation, inc. (xvza) and piloted by miguel a. gold landed on runway 13 at the fort Lauderdale-Hollywood…Incident 20040313006809ILuscom 8 · New Boston, MI(-23) The pilot departed belleville larsen airpark for carleton, wickenheiser airport for the purpose of purchasing fuel. Larsen airpark does not currently offer fueling service. After about ten minutes of flying time the engine sputtered and stopped. The…Incident 20040313006749ITcraft BC · Terre Haute, IN(-23) 03/13/2004 During climb after departure from runway 12 Terre Haute (huf) at between 300 and 400 feet and 2 miles from the airport (huf) the engine lost power and ceased to operate. The pilot attempted to return to the airport but was unable, landing the…Accident 20040313006189APiper PA28R200 · Peru, IL(-23) Pilot/cfi were practicing touch and go landings. Aircraft veered off runway 18. CFI stated that pilot selected gear up instead of flaps up at critical time during takeoff roll. According to CFI there is also a possibility that squat switch designed to…Incident 20040313003819ICessna A185F · Everett, WA(-23) During approach, pilot noted landing gear lights did not indicate left main gear was down and locked. The tower was conducted, and a fly-by of the tower was performed to evaluate the status of the landing gear. The tower personnel advised the pilot that…Accident 20040313003639AAmrgen AA1 · Selma, CA(-23) On 3/13/2004 at approximately 1445 PST, [privacy data omitted], pilot in command of American AA1 aircraft, N6175L, crashed during an aborted takeoff from Selma Airport runway 28, Selma, CA. [privacy data omitted] Was conducting an aircraft orientation…Accident 20040313003109AMaule MX7180A · Plains, GA(-23) Pilot was attempting to land on a Private airfield near Plains, Georgia. The grass airfield is not listed on the sectional for the area. The owner of the airfield, [privacy data omitted] stated that the length of the landing area was 2200 feet. The…Accident 20040312016899AAmtr 2#2 · Bunnell, FL(-23) On March 12th, 2004 at 1830 hrs EST, an experimental gyroplane was being operated under an exemption for flight instruction, and during a high speed taxi one of the two rotor blades separated from the hub bar. The gyroplane was substantially damaged,…Accident 20040312016749ARobsin R22BETA · Keystone Height, FL(-23) Instructor with commercial student were practicing air taxi manuevers at 50 ft AGL, at 50 KTS, while executing a right hand turn they suffered a sudden loss of altitude. The instructor attempted recovery, however the right skid contacted the ground and…